Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hey guys,
I have no clue what to do here:
I have a table which calculates the average amount of sales by month, hour, category and title like this:
Month name | Hour | Category | Title | Avg. Am. Sales |
February | 13 | 1 | A | 1 |
February | 19 | 1 | B | 2 |
February | 17 | 1 | C | 2 |
February | 14 | 1 | A | 1 |
March | 13 | 2 | A | 1 |
The measure "average amount of sales" refers to a column in a table and is defined as:
Average amount of sales =CALCULATE(AVERAGE(SALES[SALES]),ALL(Calendar[Date]))
So far so good. But now I want to use these averages as a forecast for future dates (incl. time). I created a table like this:
Date+Time | Category | Title | Forecast Am. Sales |
10.02.2024 13:30 | 1 | A | 1 |
27.03.2023 13:45 | 2 | B | 1 |
01.02.2023 17:01 | 1 | C | 2 |
So, when I put in the measure, it deletes all future entries and does only show sales of the past.
For sure, this is exactly what is meant to happen, but I have absolutely no idea how to create a new measure that calculates an average for past amount sales and uses it as a forecast for a future date and time.
Could you help me out here? Thanks a lot!
But now I want to use these averages as a forecast for future dates (incl. time)
Which forecast methodology are you planning to apply? Do you care about seasonality? Do you care about weekdays/workdays/holidays? DST?
Thanks for your reply. I think that sounds really interesting and I would try if this makes sense for my model. But as I even fail with just averages for future dates I thought that would be the first step of understanding.
In the meantime I tried a few more measures and when I refer to columns like Date+Time (like ALL(SALES[Date+Time])) it creates Dates in the future that weren't in the original table... I think this ALL-function doesn't work for me here...
Check out the May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
71 | |
70 | |
51 | |
47 |
User | Count |
---|---|
45 | |
38 | |
33 | |
30 | |
28 |