Quick summary
Custom columns in Power BI let you extend your data tables by writing DAX formulas that calculate new values directly within the Table view. This step-by-step process helps analysts enrich datasets without modifying the original data source.
Steps
- Open Power BI Desktop, navigate to the Home tab, and select Blank report to start a new project.
- Choose a data source to connect and add data to your report.
- Click Load to import the selected data into Power BI.
- Switch to the Table view using the view selector on the left sidebar.
- Click New column in the ribbon to open the formula bar.
- Enter a DAX formula (Data Analysis Expressions) in the empty formula field to define your custom column.
- Click the check icon to commit and apply the DAX formula to the table.
- Press Enter to confirm, and your new custom column will appear in the table view.
