Using Addmonths in IF Statement for Dimension

[Anonymous]

Hi,

I use this if statement but it does not bring back 2 months, it brings back all available months in a Year.

if(date#(GLPeriod.PeriodNameRP,'MMM-YY') >= $(=addmonths(date#(only(GLPeriod.PeriodName),'MMM-YY'),-2))
,date#(GLPeriod.PeriodNameRP,'MMM-YY'))

Please let me know if i did any wrong.

Thanks

Dev

[shwethaa]

Hi Dev,
Try below expression
if(Date(date#(GLPeriod.PeriodNameRP,'MMM-YY')) >= Date(addmonths(Date(date#(Min(GLPeriod.PeriodName),'MMM-YY')),-2))
,Date(date#(GLPeriod.PeriodNameRP,'MMM-YY')))


-Shwetha A

[Anonymous]

Nope, it gives Error in Calculated Dimension. But the window says Expression is Ok.

[Anonymous · Accepted solution]

It worked when i created the function as variable
vMonth5 variable is set with =addmonths(date#(only(GLPeriod.PeriodName),'MMM-YY'),-5)
and in IF
=if(date#(GLPeriod.PeriodNameRP,'MMM-YY') >= vMonth5
,date#(GLPeriod.PeriodNameRP,'MMM-YY'))