Create a calculation column
Creating a calculated column is a simple process but you should consider the following points before you begin:
You must create a supported column type and then define the calculation.
Sorting is disabled on:
A calculated column that contains a column of a parent row.
A calculated column that contains a logical column (for example, address column).
A calculated column that contains another calculated column.
Calculated columns can span two tables only.
A calculated column can contain a column from another table (spanning two tables: current table and parent row).
A calculated column can't contain a calculated column from another table that also contains another column from a different table (spanning three tables).
Follow these steps to create a calculated column:
Open Power Apps.
Select Tables from the left-side navigation panel.
Find/select your table, from the Schema pane, select Columns, and then select + New Column.
Provide the required information for the column, including the Display name and Data type.
Add a calculation by selecting Behavior > Calculated.
Note
Selecting Calculated will force you to save changes to the table, before creating/editing the calculation.
Save the column.
After you save the column, the calculated column definition editor opens in a pop-up window. Your column exists now, but there's no formula for it yet. The calculated column definition consists of two sections: CONDITION and ACTION. Notice that the condition property is "optional".
Select + Add condition.
In the Condition section, you can specify an Entity (table), Field (column), operator, type, and value.
In the Entity drop-down box, you can choose a current table or a related table.
In the Field drop-down box is a selection of all available columns for the table.
Depending on the Operator that you choose, you might need to provide the Type and Value as well.
You can specify multiple conditions by selecting + Add condition and incorporate AND or OR operators.
Once you're complete with your condition, select the check mark.
Select + Add action to add an action.
Provide a formula for the calculated column. When you're complete with your formula, select the check mark.
Optionally, you can add an Else condition with condition and action parameters.
Once you've completed setting up your calculation, select Save to save your work or Save and Close to save and close the calculated field editor.