Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Simulating user base growth

Hi,

I am trying to model user base growth.

 

I have created a table with 60 periods

Periods table = GENERATESERIES(1, 60, 1)

 

I have defined a parameter named growth rate:

p_Users growth rate = GENERATESERIES(0.5, 2, 0.1)

 

In my assumption I decide to have a target of X number of users each month, eg. 1000.

 

How should I construct the measure, which shows:

- the sum of users per period, I want 

current period users = previous period users + growth rate * target

 

Why do I want to do that in measure? Because I want to use dynamic slicers to play around with multiple values.

Thanks for help

All the best

Marcin

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Anonymous,

    AFAIK, power bi does not support dax formulas to do recursive calculation based formula its previous calculation result with current values.

    Perhaps you can take a look at the following blog to use EXP and LN functions to calculate out current rate to achieve your requirement:

    Recursive Calculations in PowerPivot using DAX 

    Regards,

    Xiaoxin Sheng

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Anonymous,

    AFAIK, power bi does not support dax formulas to do recursive calculation based formula its previous calculation result with current values.

    Perhaps you can take a look at the following blog to use EXP and LN functions to calculate out current rate to achieve your requirement:

    Recursive Calculations in PowerPivot using DAX 

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi, 

      The problem is not using the measure in slicer, but how to build a meausre. I already have a parameter and that parameter works well in slicer, yet am struggling to build a measure, which is kind of a generated series.