Date with Max value

[everest226]

How to get date of last months which has highest value . dimension is Day-week.

I want to capture 15 Tuesday  as shown in attachment

[sunny_talwar]

May be like this:

FirstSortedValue([Day-week], -Aggr(Sum(value), [Day-week]))

[sunny_talwar]

Replace Sum(value) with whatever expression you are using in your chart

[#4]

everest226‌

[sunny_talwar]

Is your issue still not resolved?

[everest226]

hi  i want to use set analysis for this to do . this is my expression in the chart

=Max(Aggr(Count (DISTINCT {<Year={'$(=max(Year))'}, Month-={"$(=month(date#(max({<Year={'$(=max(Year))'}>}Month),'MM')))"}>} [Authenticated user]),[Date Time]))

[everest226 · Accepted solution]

=concat ( distinct IF( aggr ( Rank( Count (DISTINCT   

[user])), [Date Time])<=1, 

[YYYY-MMM] ), ', ' ,    num([YYYY-MMM]))

thanks Sunny i was able to get the result