Power BI – DAX Measures

DAX Measures are used for Data Analysis in Power BI. A calculator sign on the fields displays it. Set sum, averages, minimum, maximum, etc. through the fields using the Measures.

Input File: MonthlyProfit.xlsx
Output Saved as: AMIT DAX Measures.pbix

Calculate the value of the new measure using the DAX formula. The measures are created and displayed in Report ViewData View, or Model View.

Click Get data and then Excel workbook or directly click Excel Workbook. Select your Excel file MonthlyProfit.xlsx and click Open:

Open your excel workbook in Power BI

Now, click Load:

Load your excel data in Power BI

After loading the data, go to the Data and select both columns. Also, select the table from the Visualizations pane. This will create the table:

Create a table from the data in Power BI

Let us now click New Measure:

Click the New Measure tab in Power BI

We added the following formula. The projected profit is set to twice the current profit. Here, Projected Profit is the name of our Measure. The ProfitByMonth[Profit] is the Profit column of the ProfitByMonth table:

Above, the:

  • SUM() is the DAX Function.
  • The referenced table is ProfitByMonth.
  • The referenced column is Profit in the ProfitByMonth

We have set the above formula:

DAX Measure formulae set in Power BI

After pressing enter, the formula will execute. We have selected the columns and created a table with the Projected Profit column as well:

DAX Measure formulae executed in Power BI

Using the same two columns as well as the new Projected Profit column, we will create a Clustered Column Chart:

Create a Clustered Column Chart from the DAX Measure result in Power BI

Press CTRL+S and save it. We will name it AMIT DAX Measures.pbix. Click Save.


If you liked the tutorial, spread the word and share the link and our website Studyopedia with others.


For Videos, Join Our YouTube Channel: Join Now


Read More:

Power BI - DAX Calculated Columns
Power BI - What is a Report
Studyopedia Editorial Staff
contact@studyopedia.com

We work to create programming tutorials for all.

No Comments

Post A Comment

Discover more from Studyopedia

Subscribe now to keep reading and get access to the full archive.

Continue reading