Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey guys,
I've been stucked in a problem for a few days and I need help.
I want to create a measure to calculates recursively the price for n current Month.
My formula is the same as below:
PriceN = PriceN(month-1)*Lambda + (1-Lambda)*Price(month-1)
Example:
Can anyone help me please to solve this problem within Power BI?
Thanks in advance
Solved! Go to Solution.
Hey @Anonymous ,
in this blog i describe how table iterators can be used to overcome the lack of recursive capabilities, maybe you will find this useful: Using Table Iterators to calculate a future value - Mincing Data - Gain Insight from Data (minceddata.info)
Hopefully, this helps to tackle your challenge.
Regards,
Tom
Hey @Anonymous ,
in this blog i describe how table iterators can be used to overcome the lack of recursive capabilities, maybe you will find this useful: Using Table Iterators to calculate a future value - Mincing Data - Gain Insight from Data (minceddata.info)
Hopefully, this helps to tackle your challenge.
Regards,
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |