Max Date, Aggr Months

[george55]

Hi all,

Need the Max Date of a moth and take their value. And this for each month. This formula brings correct results:

Sum({<%Date={'$(=Max(%Date))'}>} TimetoCount )

but it shows only 1 month, only the last month (Mär). Result should look like this below but with the formula above.

Thanks.

[lorenzoconforti · Accepted solution]

Try something along these lines:

=FirstSortedValue(aggr(sum(TimetoCount ), Date ),-aggr(only(Date) ,Date))