Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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
May be this
Sum({<PK_Date = {"=MonthName(PK_Date) = MonthName(Today(), -1)"}>}Measure)
May be this
Sum({<PK_Date = {"=MonthName(PK_Date) = MonthName(Today(), -1)"}>}Measure)
Thanks