cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
naocisneros Frequent Visitor
Frequent Visitor

Re: SAMEPERIODLASTYEAR()

This worked for me:

 

nest two funtion: add date and previous month

 

Importe MismoMes AñoAnt =
CALCULATE(
SUM('MR GOPMX_ViewA'[Importe MN]), DATEADD(PREVIOUSMONTH(DateDim[FullDateAlternateKey]),-11,MONTH))

naocisneros Frequent Visitor
Frequent Visitor

Re: SAMEPERIODLASTYEAR()

This worked for me:

 

nest two functions: date add and previous month.

I have a table created / have the property configured as a date table.

 

Importe MismoMes AñoAnt =
CALCULATE(
SUM('MR GOPMX_ViewA'[Importe MN]), DATEADD(PREVIOUSMONTH(DateDim[FullDateAlternateKey]),-11,MONTH))