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?
The above tells PowerBI to pull the closing principal date for the month prior.
Now this all works great when i put it into a TABLE visualization, but i can't extract this data (I have more than 30K rows) and I can't pull this into a table because the iteration for the measures breaks when i pull it into another table using the SUMMARIZE or ADDCOLUMNS formulas.
Has anyone been able to succeed in doing something similar? Can you please share how you were able to take the calculated data in the visualization table and either extract it or place it into a new table?
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: