Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

waterfall chart - math

Ok, so trying to wrap my head around this math.   I understand how the waterfall chart works in Power Bi in terms of adding/subtracting between periods.       What I don't get is the math.   This c...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    The maths is correct. 

     

    If you start with 9, then 9=100% of your starting quantity 

    9+9+9+9 = 100%+100%+100%+100% = 36 = 400% of 9

    100/9 x 45 = 500% = Therefor, a 400% increase. 

     

    If you start with 45, then 45 = 100% of your starting quantity 

    100/45  x 76 = 168% = Therefor, a 68% increase. 

     

     

    Think of it this way, 

    You have 2 apples. Therefore, 100% of the apples that you have = 2. right? 

    Now, you are given 4 more apples. If your original quantity was 2 but now it's 6, you've got three times the apples, therefore, 3 times 100% = 300% . So the change would be 200% (because you started with 100% (300% - 100% = 200%) 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

The maths is correct. 

 

If you start with 9, then 9=100% of your starting quantity 

9+9+9+9 = 100%+100%+100%+100% = 36 = 400% of 9

100/9 x 45 = 500% = Therefor, a 400% increase. 

 

If you start with 45, then 45 = 100% of your starting quantity 

100/45  x 76 = 168% = Therefor, a 68% increase. 

 

 

Think of it this way, 

You have 2 apples. Therefore, 100% of the apples that you have = 2. right? 

Now, you are given 4 more apples. If your original quantity was 2 but now it's 6, you've got three times the apples, therefore, 3 times 100% = 300% . So the change would be 200% (because you started with 100% (300% - 100% = 200%)