Forum Discussion
jennab8268
3 years agoFrequent Visitor
Financial Reporting
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.
1 Reply
- Greg_DecklerCommunity Champion
jennab8268 Without at least mocked-up data, hard to be specific but these may help:
Better Rolling Average - Microsoft Power BI Community