Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@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
User | Count |
---|---|
99 | |
90 | |
85 | |
74 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |