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

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.