Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
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
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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.
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |