Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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(
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))
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))
Thank you! This really works!