cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bullius Member
Member

MAX of SUM values

2 REPLIES 2
AlexChen Member
Member

Re: MAX of SUM values

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.

 

 

5.png

 

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]))

 

6.png

 

Best Regards

Alex

bullius Member
Member

Re: MAX of SUM values

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!