Get last value of max date of each period ignoring date filter

[maryna_hubska]

Hello!

I need to find value of data of max date in each period ignoring global date filter.

I use

FirstSortedValue(
{1<Type={'warehouse_data'}, [Date.Calendar.Year], [Date.Calendar.Month], [Date.Calendar.Quartal], [Date]>}
aggr(sum(quantity*product_price),[Date]), -aggr(Date, Date))

But this doesn't work(

[BrunPierre · Accepted solution]

FirstSortedValue({<Type={'warehouse_data'}, [Date.Calendar.Year]=, [Date.Calendar.Month]=, [Date.Calendar.Quartal]=, [Date]=>}
aggr({<[Date.Calendar.Year]=, [Date.Calendar.Month]=, [Date.Calendar.Quartal]=, [Date]=>}

Sum({<{[Date.Calendar.Year]=, [Date.Calendar.Month]=, [Date.Calendar.Quartal]=, [Date]=>}quantity*product_price),[Date]),

-aggr({<[Date.Calendar.Year]=, [Date.Calendar.Month]=, [Date.Calendar.Quartal]=, [Date]=>} Max({<[Date.Calendar.Year]=, [Date.Calendar.Month]=, [Date.Calendar.Quartal]=, [Date]=>}Date), Date))

[maryna_hubska]

Thank you! This really works!