Forum Discussion

BabyBinki821's avatar
BabyBinki821
Helper I
4 years ago
Solved

Weekly Growth Rates

Hi   Another DAX measure that is driving me nuts. I have bar chart with cumulative accounts over time. I am tring to calculate the growth rate from week to the next. I cannot figure it out 😞 Any s...
  • BabyBinki821's avatar
    BabyBinki821
    4 years ago

    Thank you!!! This worked perfectly. One question - some of the %s are off by one decimal - what would be the reason for that. Both my total ordering accounts and previous week are set as whole numbers.

  • Whitewater100's avatar
    Whitewater100
    4 years ago

    Hi:

    I'm wondering if it's a rounding thing? 

    You could try some rounding functions like

    The following expression rounds 1.3 to the nearest multiple of .2. The expected result is 1.4.

    DAXCopy
     
    = MROUND(1.3,0.2)

    :Can you markthe initial question as solved? Thanks...

     

BabyBinki821's avatar
BabyBinki821
Helper I
4 years ago

Thank you!!! This worked perfectly. One question - some of the %s are off by one decimal - what would be the reason for that. Both my total ordering accounts and previous week are set as whole numbers.

Whitewater100's avatar
Whitewater100
Solution Sage
4 years ago

Hi:

I'm wondering if it's a rounding thing? 

You could try some rounding functions like

The following expression rounds 1.3 to the nearest multiple of .2. The expected result is 1.4.

DAXCopy
 
= MROUND(1.3,0.2)

:Can you markthe initial question as solved? Thanks...