MTD set analysis

[etrotter]

Hi, could you please let me know what I'm doing wrong:

Sum({$<Month(Date)=$(vCurrentMonth)>}[Total Revenue])

vCurrentmonth=Max(Month(Date))

Thanks in advanced!

[sunny_talwar]

You cannot use Function on the left hand side of the set modifier... create Month(Date) as Month in the script and then use it like this

Sum({<Month = {'$(=Max(Month)'}>} [Total Revenue])

[etrotter]

its still not working, I do have a 'month' field in the model but it is unrelated to total revenue. The table is related to the 'date' field

[etrotter · Accepted solution]

Got it!

Sum({<[EntryYearMonth]={"$(=MaxString([EntryYearMonth]))"}>}[Total Revenue])