Measured with percentage change

[Anonymous]

I am trying to calculate in percentage the variation of two values ​​between this year and last year.

Last year's value in February:

2020 value = CALCULATE(SUM(Estoque[QTD]),DATESBETWEEN(Estoque[D1].[Date],DATE(2020,02,01),DATE(2020,02,28)))+0

Current year's value in February:

2021 value = CALCULATE(SUM(Estoque[QTD]),DATESBETWEEN(Estoque[D1].[Date],DATE(2021,02,01),DATE(2021,02,28)))+0

To calculate the variation I do:

%variation = DIVIDE(Estoque[2021 value]-Estoque[2020 value],Estoque[2020 value])+0

The measures from last year and from that year return values, but the variation in% is incorrect. Would anyone have any suggestions?

[Anonymous]

I already changed the DIVIDE() parameter, thanks.

My YoY% formula returns the correct result.

I don't know what could it be to return the percentage 0,00%.

[lbendlin]

Note that DIVIDE() has an "or else"  option, so there is no need for your "+0"  shenanigans.

Your YoY% formula looks accurate. Have you verified that your values for the years return the correct result?