Simulating user base growth

[macinr]

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

[v-shex-msft · Accepted solution]

HI @macinr,

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

[aj1973]

Hi @macinr 

Not easy to use a meaure directly into a slicer. I recommend this

https://community.powerbi.com/t5/Desktop/Cannot-use-measure-in-slicer/td-p/166909

Good luck

[macinr]

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.