Forum Discussion
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 anyone can help it will be greatly appreciated!
Sample data:
| Vendor | Words | YearMonth | Max |
| Jim | 650 | 2018/09 | 1250 |
| Jim | 600 | 2018/09 | 0 |
| Tim | 100 | 2018/05 | 0 |
| Tim | 300 | 2018/03 | 300 |
| Matt | 500 | 2018/02 | 500 |
| Matt | 400 | 2018/01 | 0 |
| Jake | 600 | 2018/01 | 0 |
| Jake | 700 | 2018/10 | 900 |
| Jake | 200 | 2018/10 | 0 |
| Tom | 900 | 2018/12 | 900 |
| Tom | 400 | 2018/01 | 0 |
| Tom | 100 | 2018/11 | 0 |
I am trying to find the max amount of words each person can write in a month if there are multiple entries per month then I am looking to sum them together. I am trying to filter by vendor and YearMonth. I only want to see the Max amount each person can do. If anyone can help me write a formula I would really appreciate it.
Thanks in advance!
2 Replies
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
