Percentage difference

[clem312]

Hi everyone,

I am trying to make a difference between 2 percentages for 2 different years.

My formula doesn't work :

Significance = ABS(CALCULATE([Measure], FILTER(Q74a, Q74a[Annee_lib]=2020))- CALCULATE([Measure], FILTER(Q74a, Q74a[Annee_lib]=2019)))

[Juventus]

Hi @clem312 ,

go through the below steps.

How to Calculate YOY Growth

Now that you know why it’s useful, you have a better frame of reference to evaluate your YOY growth calculations. So let’s dig into how, exactly, you do that. The first step is to collect the data you’re going to need: your monthly data for the period you’re examining, and the same information for the period recorded 12 months prior.

Once you’ve got your raw materials, the process itself is quite simple and takes three steps:

1. Take your current month’s growth number and subtract the same measure realized 12 months before. If the difference is positive, your organization experienced growth; if it’s negative, that indicates a loss.
2. Next, take the difference and divide it by the prior year’s total number. This will give you the growth rate for your 12-month period.
3. Multiply it by 100 to convert this growth rate into a percentage rate.

Let’s use a real-world example to illustrate this. Imagine your monthly revenues for January 2018 were $1,000 dollars and revenues for January 2017 were $950.

1. Start with subtraction, giving a year over year difference of $50 ($1000-$950).
2. Divide $50 by $950, giving you a growth rate of 0.05.
3. Multiply it by 100 for your final percentage growth rate of 5%. Easy!

Regards,

Rakesh Js

[clem312]

@Juventus 

Thank you for your reply but I really the difference not the increase. 

Because I am calculating the significative difference :

Abs(P1-P2)/root(((P1*(100-P1)/N1)+(P2*(100-P2)/N2))

[v-jingzhang · Accepted solution]

Hi @clem312 

What is the formula for [Measure]? Can you share it as well as some sample data?

Maybe you can try this formula:

Significance =
ABS (
CALCULATE (
[Measure],
ALLEXCEPT ( Q74a, Q74a[matrix row field name] ),
Q74a[Annee_lib] = 2020
)
- CALCULATE (
[Measure],
ALLEXCEPT ( Q74a, Q74a[matrix row field name] ),
Q74a[Annee_lib] = 2019
)
)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.