Returning the Max value

[Anonymous]

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!

[v-yuta-msft]

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

[LivioLanzo · Accepted solution]

Hi @Anonymous

check the file here: https://1drv.ms/u/s!AiiWkkwHZChHj1CvCpKtyEyBnx6D