Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I want to create a forecast of sales using the average of actual sales over the past several weeks as the forecast. See below for an example of the data I have and what I'm trying to acccomplish. I have measures for Daily Sales, Sales Lagged 1 Week, and the average of the first 2 measures. What I want to create is a measure that yields the results in the Forecast column. Each value in this column is the most recent value for that day (Mon, Tues, Wed, etc.) from the Average column. I want to extend the forecast column through the last date in the my Calendar table which is the end of the current year. Any help will be greatly appreciated.
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
All measures are in the attached pbix file.
This was extremely helpful - exactly what I was looking for. Thank you for the quick response.
Hi,
Please check the below picture and the attached pbix file.
All measures are in the attached pbix file.
This was extremely helpful - exactly what I was looking for. Thank you for the quick response.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |