Solved! Go to Solution.
Simple, just subtract 1 from the date
so Current period -1
However, that will only work if your Current Period is the first month of the Timescale
This is how to make it work for any month in the Current Period setting
1. Set up a Time Lookup module (no dimensions), as below
Formulas are:
Current Year = PERIOD(CURRENTPERIODSTART()) with the line item formatted as Time Period:Year
CY Start = START(Current Year) with the line item formatted as Date
CY End = START(Current Year) -1 with the line item formatted as Date
I hope this helps
David