Display the max date of a values given an indicator

aj_954 — Mon, 11 Oct 2021 16:39:57 GMT

Hi,

I want to display the max date for a given set of values filtered by an indicator:

What I have so far:

= FirstSortedValue(DISTINCT [Dates.autoCalendar.YearMonth],-price)

however, that is giving me the max date for all the values:

I tried this:

= FirstSortedValue(DISTINCT [Dates.autoCalendar.YearMonth],-Max({<indicator={'QQ'}>}price))

but I get the error " error in expression: nested aggregation not allowed"

What can I do to fix it? I know I need to use AGGR() but I am getting a null value .

Re: Display the max date of a values given an indicator

stevejoyce — Mon, 11 Oct 2021 18:16:42 GMT

= FirstSortedValue(DISTINCT [Dates.autoCalendar.YearMonth],-aggr(Max({<indicator={'QQ'}>}price),[Dates.autoCalendar.YearMonth]))