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. I would like to calculate the projected net outstanding amount which is based on the current outstanding.
In Week 1, the 'Net outstanding' is calculated by substracting the 'Net risk' from the 'Current outstanding'. However, in Week 2, the 'Net risk' should be subtracted from the previous 'Net outstanding' (hence from Week 1) and not from the 'Current outstanding'.
I am looking for the below output.
Note: I have a live connection to an Azure Analysis Service database, so I am not able to add columns in the editor nor query.
Solved! Go to Solution.
It looks like you can do a cumulative sum of Net risk plus the Current outstanding amount.
It looks like you can do a cumulative sum of Net risk plus the Current outstanding amount.
Thank you for that very easy solution - which worked!
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 |
---|---|
42 | |
21 | |
18 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |