cancel
Showing results for 
Search instead for 
Did you mean: 

Custom Measure for Last Year

cecilia_petersson2
Active Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
Active Participant
0 Kudos

Thanks Mattias 🙂

/Cecilia

Answers (0)