Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
Hi @Anonymous
check the file here: https://1drv.ms/u/s!AiiWkkwHZChHj1CvCpKtyEyBnx6D
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
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
Hi @Anonymous
check the file here: https://1drv.ms/u/s!AiiWkkwHZChHj1CvCpKtyEyBnx6D
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |