Forum Discussion

clem312's avatar
clem312
Resolver I
4 years ago
Solved

Percentage difference

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)))
 

 

 

  • 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.

3 Replies

  • 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's avatar
      clem312
      Resolver I

      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's avatar
        v-jingzhang
        Community Support

        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.