Error when trying to calculate YoY% last year doesn't match previous year

[squarecat]

Hello everyone, I'm going crazy trying to figure out what am I doing wrong when attempting to calculate YoY%. I started trying to sum up all the values in the [Saldos] column that are marked as "Ingresos" in the [Tipo] column with the following measure:

Ingresos =
CALCULATE(SUM('Base datos'[Saldos]),
'Base datos'[Tipo] = "Ingresos")

This apparently works fine, so I use the new measure to calculate [Ingresos] for last year with the dateadd function:

Ingresos LY = 
CALCULATE(CALCULATE([Ingresos],
DATEADD(Calendario[Date], -1, YEAR)))

It seems to work fine for every year except the last, that should be 5,725,873.31 but is short by more than a million, so I can't calculate YoY% because the last year doesn't have the correct value

Where am I going wrong?

[Kedar_Pande]

@squarecat 

Ingresos measure looks good.

Ingresos LY = 
CALCULATE(
[Ingresos],
SAMEPERIODLASTYEAR(Calendario[Date])
)

YoY% = 
IF(
NOT(ISBLANK([Ingresos LY])),
DIVIDE([Ingresos] - [Ingresos LY], [Ingresos LY])
)

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[squarecat]

Tried it but still shows wrong value

[Bibiano_Geraldo]

Try the folowing DAX:

Ingresos LY =
CALCULATE([Ingresos],
SAMEPERIODLASTYEAR(Calendario[Date])
)

if this answer help you, please, mark it as solution.

[squarecat]

Wrong value still

[MNedix · Accepted solution]

Heya,

Have you tried:

Ingresos LY = 
CALCULATE([Ingresos],PREVIOUSYEAR('Date'[Date]))

[squarecat]

This is the solution, thank you very much!