Forum Discussion
Find Max Day per Week
Hi,
I think you have misunderstood my data, and the last day of each week only represents this week and the max value is not the end day's value.
So i add an column to the original table:
Week = SWITCH('Table'[WeekEnd],DATE(2020,2,8),"Week-1",DATE(2020,2,15),"Week-2",DATE(2020,2,22),"Week-3")And i think you should already have the column like the above to represent each week.
The result shows:
Here is my test pbix file:
Best Regards,
Giotto Zhi
Hi,
I add some data to my original test file.
Please try this measure:
Measure =
var a = TOPN(1,SUMMARIZE('Table','Table'[Date],"Count",COUNTROWS('Table')),MAX([Count]),DESC)
var maxDate = MAXX(a,'Table'[Date])
return
DAY(maxDate)Then choose [WeekEnd] column and this measure, the result shows:
Best Regards,
Giotto Zhi
It's only getting the max value for the last day of the week. I'm looking to take the max per week, not just the max at the end of the week
If you are looking for only max value per week, then rank can help.
rankx(all('User Table'[Week end date]),MAX ( 'User Table'[Percentage] ),,desc,dense)
How to filter on rank:https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
If you need a max value on the max date of the week , that is a different context
Hi,
I think you have misunderstood my data, and the last day of each week only represents this week and the max value is not the end day's value.
So i add an column to the original table:
Week = SWITCH('Table'[WeekEnd],DATE(2020,2,8),"Week-1",DATE(2020,2,15),"Week-2",DATE(2020,2,22),"Week-3")And i think you should already have the column like the above to represent each week.
The result shows:
Here is my test pbix file:
Best Regards,
Giotto Zhi
I'm still not getting correct results
