Creating a calculated table in Power BI lets you generate a new table using DAX expressions based on existing tables in your model. Here’s how:
- Open Power BI Desktop. Go to the 'Table' view.
- Click 'New Table'.
- Write your DAX (Data Analysis Expressions) formula in the empty field.
- Click on the check icon to apply and commit the expression.
- Creates a new table that's been calculated.