The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello everyone,
I have a pretty hard to explain situation which I'd like to solve, I'll give it a go:
I have 3 tables:
So let's say I have a customer and to keep it simple this example has only 3 years of subscription.
Name | Year | Costs |
Customer 1 | 2021 | 4000 |
Customer 1 | 2022 | 1000 |
Customer 1 | 2023 | 1000 |
So the total costs are 7000, the customer will pay a yearly amount in a spread of the 3 years: 6000 / 3 = 2000 (index excluded)
And let's say my index table looks like this
Year | Index |
2020 | 2% |
2021 | 3% |
2022 | 3% |
2023 | 4% |
Now, the first year has no index, so indexing the subscription only starts from the second year.
How can I produce a table calculating the amount of money that must be paid by the customer, index included?
It would look like this (the amount is calculated from the amount of last year + index):
Name | Year | Amount | Index |
Customer 1 | 2021 | 2000,00 | 0% |
Customer 1 | 2022 | 2060,00 | 3% |
Customer 1 | 2023 | 2142,40 | 4% |
I hope I've explained clear enough, thanks in advance for anyone's time and effort.
Solved! Go to Solution.
HI @mrleijzer,
Current power bi does not support recursion calculation in Dax formula. You can take a look at the following link about Dax recursion to know more about these:
Previous Value (“Recursion”) in DAX – Greg Deckler
Regards,
Xiaoxin Sheng
Thanks, with this I found a workaround!
HI @mrleijzer,
Current power bi does not support recursion calculation in Dax formula. You can take a look at the following link about Dax recursion to know more about these:
Previous Value (“Recursion”) in DAX – Greg Deckler
Regards,
Xiaoxin Sheng
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
95 | |
93 | |
85 | |
68 | |
65 |
User | Count |
---|---|
241 | |
124 | |
120 | |
81 | |
79 |