Financial Reporting

[jennab8268]

Using Power Bi desktop. I would like to take revenue per day and create a rolling average to the per day  revenue needed to hit a specific year end goal. 

Example. if I am $200 below daily goal on any given day in order to hit year end goal, i want the rolling average day to adjust for the previous lost and provide a new value of what the daily average revenue should be going forward to still hit the goal. 

Note: not able to present sample data due to confidentiality. 

[Greg_Deckler]

@jennab8268 Without at least mocked-up data, hard to be specific but these may help:

Better Rolling Average - Microsoft Power BI Community

While Loop - Microsoft Power BI Community

Days of Supply - Microsoft Power BI Community