Forum Discussion
Budget Burn Rate
Hi, I was able to calculate the runrate for an ID but my problem now is how to forecast whether the ID will exceed its budget before it reaches the last Flag Date. I only have the latest Actuals and Remaining values, what I'd like to do is subtract the Flag Date's Run Rate value from the latest Remaining value then use the difference as the next minuend. Hope my explanation makes sense 😅
1 Reply
- lbendlinSuper User
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523