Forum Discussion
Compare aggregated values and select max
I need help to summarize the data for a category per user and count the results filtered by max value for each user For ex: In the below image, user - "SL-08" has an entry for category - H and 2 ...
amitchandak
Super User
Super UserAnonymous , Try like
lastnonblankvalue(Table[Date], max(Table[Categort]))
Week calendar - https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482
WOW -https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123