calculate parallel period in columns

[Anonymous]

Hi Everyone, 

I have a column with some dates or periods,  I need a calculated column with the parallel period, for example teh first result has to be January, 2017, the table is like this: 

Date

january, 2018

february, 2018

march, 2018

I am using this formula but the result is a blank column 

Parallel Perdiod = CALCULATE(PARALLELPERIOD(BSC_DATOS_FINANZAS_FLETES[Fecha].[Date];-1;YEAR)) 

I will appreciate some help

Thanks!

[v-yuta-msft]

@Anonymous,

Or you can create a calculate column using DAX below and then change the format with (MMMM yyyy):

Parallel Perdiod = DATE(YEAR('Date'[Date]) - 1, MONTH('Date'[Date]), DAY('Date'[Date]))

  

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Vvelarde · Accepted solution]

@Anonymous

Hi, try with this

Fecha1YPrev = EDATE(Table1[Fecha],-12)

Regards

Victor