DAX to calculate MAX of SUM Per Month

[DaniEMIT]

Hi All,

i've this issue: i need a DAX to calculate per each item the MAX sum from all the month.

For Example:

ITEM	MONTH	QtySold
AAA	JAN	10
AAA	JAN	20
AAA	FEB	5
AAA	FEB	11
AAA	FEB	3
BBB	JAN	45
BBB	JAN	3
BBB	JAN	8
BBB	FEB	12
BBB	FEB	11

The DAX i need must give as results:

AAA = 30

BBB = 56

Have you any ideas?

Thanks in advance,

Daniele

[v-jingzhang · Accepted solution]

Hi @DaniEMIT

You can create a measure with below code and put it in a table visual along with the ITEM column. 

Measure = 
var tbl = SUMMARIZE('Table','Table'[MONTH],"Total Sold",SUM('Table'[QtySold]))
return
MAXX(tbl,[Total Sold])

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[mohammedadnant]

Hi @DaniEMIT 

To get the max of Sum per month, please watch this video

https://youtu.be/eqqMtXN_D8M

like this, you need to create your DAX

Thanks & Regards,

Mohammed Adnan

Learn Power BI: https://www.youtube.com/c/taik18

[HPC]

Thank You. I am a beginner. Like your solution. Simple and clear. It worked for me perfectly. 

[DaniEMIT]

Hi Mohammed,

thanks for your reply.

Your solution is not working as i need. With the DAX, i need only one result per Item. The result must be the max value of the sum per month.