MAX of SUM values

[bullius]

Please see: https://community.powerbi.com/t5/Desktop/MAX-of-SUM-values/m-p/55306#M22431

[AlexChen]

Hi,

I assume your table called “categoryInfo”.

You can create a column called “weekOfYear” to get the week of year from “Week Commencing” in Query Editor. See screenshot below.

Now you can called a measure to calculate the sumAmount by weekOfyear:

sumAmountByWeek = CALCULATE(sum(categoryInfo[Amount]), ALLEXCEPT(categoryInfo, categoryInfo[WeekOfYear]))

Then you can create a measure to calculate max sumAmount:

maxSumWeekAmount = CALCULATE(MAXX(ALL(categoryInfo[WeekOfYear]), categoryInfo[sumAmountByWeek]))

Best Regards

Alex

[bullius]

Thanks for the reply @AlexChen,

For some reason I managed to create duplicate posts. The other is found here and has some solutions already accepted on it. Please add your suggestion to that post and I will delete this one.

Thanks!