Name of Month corresponding to the MAX value

[jlampard40]

Hi guys - I have some set analysis:

=max( aggr( count({<Activity_or_Demand={'Demand'}, Financial_Year_Week-={'2099-41'}, Room-={'CTSIM','CTSIM2'}>} Event_Key]), [Calendar_Year_Month]))

This shows me the MAX value within my data.  What I now need to show is the corresponding date (Calendar_Year_Month) that this applies to.  I have this data as a bar chart, spanning 5 years, so I am adding a text box next to it to show our users during which date (Calendar_Year_Month) the MAX value occurred in.

Thank you!

[Marcos_Ferreira_dos_Santos]

Hi Jlampard40

Have you found the solution for that need ? I hope so.

It seems a case for using the FIRSTSORTEDVALUE function, doesn't it?

Personally, I got to understand this in this worth reading article: https://www.analyticsvidhya.com/blog/2014/02/aggr/#:~:text=AGGR

Best regards,

Marcos