Help with Set Analysis - 13 months previous

[chris1987]

Hi,

I'm trying to use a simple set analysis function to return a figure from 13 months ago.

I have a master calendar with "MonthID" and just need to return the sum of LineInvoiceAmount.

Here's what I thought would work:

=sum({<[MonthID]={"=(only({1<DateID={'$(=num(date(today(1))))'}>}[MonthID] )-13)"},Description=>}LineInvoiceAmount)

I can enter :

"=(only({1<DateID={'$(=num(date(today(1))))'}>}[MonthID] )-13)"

into a text box and return the correct MonthID and I can filter on that MonthID manually and return the correct results, but I can't seem to get the function to work.

Any help wold be appreciated

Cheers

Chris

[sunny_talwar · Accepted solution]

Try this

=Sum({<[MonthID] = {"$(=Only({1<DateID = {'$(=Num(Today(1)))'}>}[MonthID]) - 13)"}, Description>} LineInvoiceAmount)

[chris1987]

Genius Thanks Sunny