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.
Hi there,
I have built an iterative calculation table similar to the one described in this post:
https://community.powerbi.com/t5/Desktop/Iterative-Stock-Cover-Calculation/td-p/574257
Problem is that if i try to extract it into another table the iterations break and don't return appropriate values. Have tried the SUMMARIZE and ADD columns functions to no avail. Anyone run into this and been able to extract iterative calculations as they appear in the table visualization?
Would appreciate the help!
Hi @Anonymous ,
If is convenient, could you share some data sample which could reproduce your scenario and your desired output so that we could help further on it.
Best Regards,
Cherry
Hi there, can anyone help please?
Hi there,
Below is the sample data, quite simple really in terms of data (lol)
Column Names (| delimiter): Date|Disbursements|Payoff
Data:
1/1/19|100,000|0
2/1/19|0|-1000
3/1/19|0|-2000
The goal is to start with an opening balance of 0, end January with a closing balance of 100,000, then February the opening balance should be 100,000 and the closing balance should be 99,000 and so on.
By following @OwenAuger 's sample i created the following sums/cumulative measures:
cumulatives:
Really need everyone's help, please.
Here is the structure of the iterative calculation:
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |