Creating custom columns in Power BI lets you add new data based on your existing columns using DAX. Here’s how to do it:
- Open your Power BI desktop, go to the 'Home' tab, and select 'Blank report'.
- Select a data source to add data to your report.
- Click 'Load'.
- Go to the 'Table' view.
- Click 'New column' in the ribbon.
- Enter a DAX (Data Analysis Expressions) formula in the empty field.
- Click the check icon to commit and apply the formula.
- Press 'Enter,' and your new column will appear in the table.