How to get the previous period of current period

MadhabikaM

Hi,

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.

Accepted answers

DavidSmith

@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:

IF 'Boolean check1' THEN Previous Month data[lookup:Time Lookups.Previous period] ELSE 0

I hope this helps

David

All comments

Nipsa

Hi,

Use PERIOD(CURRENTPERIODSTART()-1)

MadhabikaM

Hi @Nipsa

Thanks for your response.

I want to pick value for current months previous period only in a target line item.

My formula is

IF 'Boolean check1' THEN Previous Month data[SELECT: TIME.'Jun 17'] ELSE 0

I have hardcoded Time.'Jun 17' here as this is my current month previous period, In order to make time as dynamic I am trying to replace with your provided formula but its not working.

Note: Boolean check1 and Previous Month data are again two line items here.

Regards

Madhu

Could you please help.

DavidSmith

@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:

IF 'Boolean check1' THEN Previous Month data[lookup:Time Lookups.Previous period] ELSE 0

I hope this helps

David

MadhabikaM

Hi @DavidSmith ,

Thanks for the solution provided, It's working.

Thanks

Regards

Madhu

DavidSmith

Excellent!

Quick Links

Can you help?

Unanswered questions

Actions Editing - Not Syncing to Prod
I have a Dev and Prod environment. I have an action where I am importing data from another workspace. I am needing to map some new line items in the action so that it pulls correctly. I am updating the mapping in the Dev environment, but after I sync to Prod those changes are not flowing through. So they show updated in…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…