Quick summary
A calculated table in Power BI is created using a DAX formula in the Table view, allowing analysts to generate derived datasets without modifying the source data. This step-by-step process uses the New Table option and the DAX expression editor to define and commit the calculated table directly in Power BI Desktop.
Steps
- Open Power BI Desktop and navigate to the Table view.
- Click New Table to open the DAX formula bar.
- Write your DAX (Data Analysis Expressions) formula in the empty expression field.
- Click the check icon to apply and commit the DAX expression.
- Power BI generates the new calculated table based on your formula.
