Measures are numbers created to create graphs. Power BI calculates and returns values according to the types of aggregation we choose for the measure. We can also create our own measures to perform complex or specific calculations.
You can create your own measures with the Data Analysis Expressions (DAX) formula language. DAX formulas are similar to Excel formulas.
In the below sample I created a new measure as 'Gross Profit'
Click on the table which you intend to create a measure, and select 'New measure'
Now you can create a graph for the 'gross Profit' by location using the created measure. Drag and drop the two related columns to the reports page
You can create your own measures with the Data Analysis Expressions (DAX) formula language. DAX formulas are similar to Excel formulas.
In the below sample I created a new measure as 'Gross Profit'
Click on the table which you intend to create a measure, and select 'New measure'
Define the formula on the newly created measure. Note that you get IntelliSense to assist you with the formula creation.
No comments:
Post a Comment