Forum Discussion

jennab8268's avatar
jennab8268
Frequent Visitor
3 years ago

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.