Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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%.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |