Creating a calculated column
In this section, we will create a calculated column in Power BI Desktop to slice or filter a value or calculation on every row in a table. Let's run through the logic of what creating a calculated column means.
A calculated column is a new column that is added to an existing table. For each row of the table, the DAX formula is calculated immediately, just like using the autofill handle in Excel to fill in a formula. Be mindful of the fact that when using calculated columns, the result of the calculation is always stored in memory, unless of course it is reloaded or released when exiting or opening up Excel/Power BI. This will cause the table to be refreshed, which forces the column to recalculate. Let's see how this works:
- Open Power BI. For this example, we will be using the
SSGThemePark.pbix
file. - You can create the DAX formula in any view, but I prefer the table view so that I can identify the data and see how the data is structured...