Set Analysis Previous Month

Anonymous — Fri, 14 Jul 2017 13:38:40 GMT

Could someone give me an example of how to get the previous month's data only in set analysis for PK_Date.

I am currently using the below as a dimension, which returns previous month (then I suppress Null).

I know it would be better to make it an expression.Any help appreciated. My dimension formula is:

MonthName(MonthStart(Today())-1)=(MonthName(PK_Date)),(MonthName(PK_Date))

How do I make it a set analysis? or is there a better way?

n.b. PK_Date is month level only

Cheers

Phil

Re: Set Analysis Previous Month

sunny_talwar — Fri, 14 Jul 2017 13:40:51 GMT

May be this

Sum({<PK_Date = {"=MonthName(PK_Date) = MonthName(Today(), -1)"}>}Measure)

Anonymous — Fri, 14 Jul 2017 14:03:02 GMT

Thanks