Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Returning the Max value

Hello, I have some data that I am trying to return the max value of a column. I am newish to power bi and Dax and cannot seem to figure out how to write the proper function to complete the task. If a...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Hi jarodjp42,

 

To achieve this, create a measure using DAX formula below:

Result = MAXX(Table1, CALCULATE(SUM(Table1[Words]), ALLEXCEPT(Table1, Table1[Vendor], Table1[YearMonth])))

 

 

Regards,

Jimmy Tao