So, apparently, the DAX formulas can also be called as calculations as they calculate an input value and return a resultant value. You can create two types of expressions or calculations using DAX in Power BI; calculated columns and calculated measures.

Calculated Columns: The calculated columns create a new column in your existing table. The only difference between a regular column and a calculated column is that it is necessary to have at least one function in the calculated column. These are used when you want to create a column with filtered or sorted information.

To create a calculated column:

• 1. Go to the Modeling tab in Power BI Desktop.
• 2. Then select New Column option. A Formula bar will open showing “Column =”. You can replace the “Column” word with the column name you want.
• 3. After this, enter the expression for the calculated column on the right of the equals to sign.

Calculated Measures: A calculated measure creates a field having aggregated values such a sum, ratios, percentages, averages, etc.

To create a calculated measure:

• 1. Go to the Modeling tab in Power BI Desktop.
• 2. Then select New Measure option. A Formula bar will open showing “Measure =”. You can replace the “Measure” word with the measure name you want.
• 3. After this, enter the expression for the calculated measure on the right of the equals to sign.
• 4. Once you create the measure, you can modify your measure name with a calculator icon next to it, under the table name you created the measure in.