Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Got it!
Sum({<[EntryYearMonth]={"$(=MaxString([EntryYearMonth]))"}>}[Total Revenue])
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])
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
Got it!
Sum({<[EntryYearMonth]={"$(=MaxString([EntryYearMonth]))"}>}[Total Revenue])