Forum Discussion
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 |
| B | 6 | 30 | 30 | 50 |
What I am getting is same values for max and minimum. If I remove AcctNbr I want to be able to get 100 for A (min) and 500 for A (max)
ARPU is a measure field.
When I use MIN or MAX(ARPU), it says that I can only use it if ARPU is a column field.
5 Replies
Anonymous
Use below DAX
1.
Max ARPU Per Product = CALCULATE(max(MinMax[ARPU]),ALLEXCEPT(MinMax,MinMax[Product]))2.Min ARPU Per Product = CALCULATE(min(MinMax[ARPU]),ALLEXCEPT(MinMax,MinMax[Product]))Regards,RiteshMark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification SeriesHi, 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.
