Forum Discussion

mwen90's avatar
mwen90
Helper III
4 years ago
Solved

Calculate Difference in Column

Hi,    I have a list with the below columns (in image). I want to write a DAX where I take the highest Day No. and subtract it from the lowest Day No. .    Not sure how to do this? Also, I have u...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

mwen90 This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.