Forum Discussion
column vs measure
Hi experts,
How to turn values in a column into measure?
Cheers!
Cindy
Hi,
Measure can be created out of column based on some aggregations like SUM, MAX, AVG. You can use DAX expression for the same. You can have only one value for measure and you can slice that based on data.
Hi BusinessAnalyst,
In addition, you can take a look at the sample below. We create a measure use MAX() function to return the maximum value of [Value].
Also you can get started from these two articles:
Tutorial: Create your own measures in Power BI Desktop
DAX basics in Power BI Desktop
Best Regards,
Qiuyun Yu
2 Replies
- NidhyaMicrosoft Employee
Hi,
Measure can be created out of column based on some aggregations like SUM, MAX, AVG. You can use DAX expression for the same. You can have only one value for measure and you can slice that based on data.
- v-qiuyu-msftCommunity Support
Hi BusinessAnalyst,
In addition, you can take a look at the sample below. We create a measure use MAX() function to return the maximum value of [Value].
Also you can get started from these two articles:
Tutorial: Create your own measures in Power BI Desktop
DAX basics in Power BI Desktop
Best Regards,
Qiuyun Yu