Post

Skillwave Training
@skillwave.training

How do you track a weekly forecast, preserve history, and turn it into a meaningful waterfall view—without doing everything manually? 😫 In this video, @excelguru.ca tackles a real student question: www.youtube.com/watch?v=79Ui... #DataAnalysis #BusinessIngtelligence #DataVizualization #Excel

youtube.comBuilding a Weekly Forecast History Using Power Query (Without Manual Work!)In this video, Ken Puls tackles a real-world question from an Ask Ken Anything session of Self Service Business Intelligence Academy training course. How do you track a weekly forecast, preserve…
Skillwave Training
@skillwave.training

Final takeaway: Take the output of #PowerQuery, feed it back into itself, and build a self-growing forecast history system—just make sure to remove duplicates before appending. If you work with forecasts, budgets, or projections that change over time, this is a simple but powerful pattern. 👍

1 repost0 likes

No replies yet.