Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am trying to calculate weekly forecasting, but the following measure returns blank:
Solved! Go to Solution.
I managed to solve my problem, by creating the measure on the correct date table.
I managed to solve my problem, by creating the measure on the correct date table.
@PowerBI88
That's amazing news, sorry for not answering lately.
If you could please share your solution and accept it as Solution, so you can close this thread and other people can find it useful.
Hi, @PowerBI88
From quick observation, it looks okey, could you share a sample dataset (copyable) so I could try it on my own, please?
My dataset is full of sensitive data, I don't know how to mask it.
I checked the output with a table diagram and it is actually not blank, but the value for Forecasting PW is wrong:
I think also it is important to say that the value Forescasting Eur comes from a different table with respect to AzureUsage records (RegressionelineareApplicazoni(Fine Mese)'[ForecastingEUR])) and that the two tables are not directly related.
Kind regards
HI, @PowerBI88
Hmm, maybe you could create a Data Calendar and make a relationship to both tables and then use it in the calculation. IT could help.
Also,
I understand you can'T show me the exact data. However, if you could create a "fake" table with random values which would have the same structure, that would help me a lot.
Just make something in excel and Copy it here, so I can paste it directly to Power BI.
This is AzureUsage records Table:
Costo | DateCost | _MonthNumber | _DayNoOfYear | WeekNumber | Year | Year&Week | Forecasting Pw |
0,00 € | 28/02/2022 00:00 | 2 | 59 | 9 | 2022 | 2022-9 | 33.000 |
0,00 € | 28/02/2022 00:00 | 2 | 59 | 9 | 2022 | 2022-9 | 44.00 |
0,00 € | 28/02/2022 00:00 | 2 | 59 | 9 | 2022 | 2022-9 | 44.01 |
0,00 € | 28/02/2022 00:00 | 2 | 59 | 9 | 2022 | 2022-9 | 44.02 |
0,00 € | 28/02/2022 00:00 | 2 | 59 | 9 | 2022 | 2022-9 | 44.03 |
0,00 € | 28/02/2022 00:00 | 2 | 59 | 9 | 2022 | 2022-9 | 44.04 |
This is RegressionelineareApplicazoni(Fine Mese)
Applicazione,ForecastingEUR |
app01,75111 € |
app02,450272 € |
app03,10838 € |
this is the chain of relationships:
Kind regards
Marta
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |