Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |