Can I please get some reference how to get previous period of current period.
PERIOD(CURRENTPERIODSTART()) gives me the current period I,e Jul 17 but I need Jun 17.
Previous(period(currentperiodstart()) which is not working.
Solved! Go to Solution.
Thanks for your response.
I want to pick value for current months previous period only in a target line item.
My formula is
@MadhabikaM - You are right to remove the SELECT!
As @Nipsa indicated, create a Time Lookup module (no dimensions) with two line items
Current Period - PERIOD(CURRENTPERIODSTART())
Previous Period- PERIOD(CURRENTPERIODSTART()-1)
You then reference this in your formula: