Forum Discussion
DAX Measure for Max Value Based on Year
Hi, I have a data set that has values and the year that value was recorded. I want to create a measure that will display the maximum value for that year when I add it to a table. For example, my dat...
Anonymous ,
try like
Measure = CALCULATE(MAX('Table'[Value]),allexcept('Table'[Year]))
You can also try
Column = CALCULATE(MAX('Table'[Value]),GROUPBY('Table','Table'[Value]))