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

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…