Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
in this thread i asked How to get the latest date of existing data
Now i want to get the sum of a measure, but only from the data with the latest date.
I try this, but get the sum from all data with older dates, too.
Sum({<myDate = {"=Max({<someMeasure = {'*'}>}myDate)"}>}Sales)
How can i get the sum only from the data with the latest date?
regards,
sam
Try this
Sum({<myDate = {"$(=Max({<someMeasure = {'*'}>} myDate))"}>}Sales)
Try this
Sum({<myDate = {"$(=Max({<someMeasure = {'*'}>} myDate))"}>}Sales)