Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Get Max and Minimum

Goal: Get Minimum and Maximum value from this table Product AcctNbr ARPU Min Max A 1 500 100 500 A 2 200 100 500 A 3 100 100 500 B 4 50 30 50 B 5 40 30 50 ...
Need Help
Show and Tell
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, Anonymous ;

You could create a measure.

Min = 
MINX(ALLEXCEPT('Table','Table'[Product]),[ARPU])
Max = MAXX(ALLEXCEPT('Table','Table'[Product]),[ARPU])

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.