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.
I have a measure that calculates for each month:
real sales (if I have data) or a forecast.
Now I would like to calculate the sum of all already sold items (this year) plus the forecast for the remaining of the current year. I get an incorrect result. How can I fix this? MEASURE: Prognozowana sprzedaż
here is the file:
What am I doing wrong?
Thank You in advance.
Hi @Fistachpl I am glad you resolved it. Other solutions depend on calculation logic / inputs and requirements.
Proud to be a Super User!
Hi @Fistachpl in Tabela1 there are only data up to 20.02.2024, so the question is how to figure out what periods are current vs future / forecast if there is no data?
Proud to be a Super User!
Hello,
Sales should be until the month previous to the current one. E.g. if there is no sales data fo april and we already have may then for April should be 0, from may till the end of the year should be forecast.
I managed to calculate this anyway (was stuck for 2 days with it) but I would like to see other solutions 🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
128 | |
29 | |
28 | |
24 | |
22 |