Custom Measure for Last Year

[cecilia_petersson2]

Hi,

To simplify report creation for the users and avoid member offset, I'd like to create one measure for Last Year YTD and one for Last Year Periodic (i.e. if I create a report where Time = 2014.May and Measures = YTD, Periodic, LYYTD, LYPeriodic, I'd like to see 2014.May YTD and Periodic, and then 2013.May YTD and Periodic). I'm working in a YTD model in BPC10MS. I've found the LAG function but I don't know what the syntax would look like. Anybody having an idea?

/Cecilia

[Former Member · Accepted solution]

Dear Cecilia,

You could try:

LYYTD

(CLOSINGPERIOD([%TIMEDIM%].MONTH,[%TIMEDIM%].CURRENTMEMBER).LAG(12),MEASURES.[YTD])

LYPERIOD

(CLOSINGPERIOD([%TIMEDIM%].MONTH,[%TIMEDIM%].CURRENTMEMBER).LAG(12),MEASURES.[PERIODIC])

Brgds

Mattias

[cecilia_petersson2 · Accepted solution]

Thanks Mattias 🙂

/Cecilia