Sum of measure from latest date

[Anonymous]

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

[sunny_talwar · Accepted solution]

Try this

Sum({<myDate = {"$(=Max({<someMeasure = {'*'}>} myDate))"}>}Sales)