Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Parallelperiod issue

Hi all! 

 

I'm trying to get the sales value of the previous previous month but i'm not been able to reach it using parallelperiod formula. 

 
(CALCULATE(Consolidado[TO]; PARALLELPERIOD(Consolidado[Fecha creacion];-2;MONTH)));0))
 
My "Fecha creación" table is:
 
SOP baseIDFecha creación
Actual031/1/2015
SOP 01-Ene231/1/2016
SOP 02-Feb429/2/2016
SOP 03-Mar631/3/2016
SOP 04-Abr830/4/2016
SOP 05-May1031/5/2016
SOP 06-Jun1230/6/2016
SOP 07-Jul1431/7/2016
SOP 08-Aug1631/8/2016
SOP 09-Sep1830/9/2016
SOP 10-Oct2031/10/2016
SOP 11-Nov2230/11/2016
SOP 12-Dic2431/12/2016

 

Now we are working in March, so I must get January value. The weird thing is that if I want to get February value, it works fine using "-1".

 

Thanks for your help

 

3 Replies