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.
Hello,
I would like to verify data Compared in the historice, versus the actual data,
i think it is a modelling problem.
here is a picture of my concern
i would like to use [Clef unique article]
calculate daily on hand stock with this formula
2 thiings !
You are using DateTable in measure to get the cumulative value i guess, which is not really required
2nd thing why date table is used if you want to filter data from other table "Lignes de mouvement (img Stock)
Create a simple Table visual in that add base artical and add the value you must get the result with implied calculation!
If not , please share the sample data to resolve it!
Proud to be a Super User!
Hello @VijayP
First of all thank you for the quick reply 🙂
I'm using my calendar table because I want to have all values repeated until there's a stock movement.
If I do not use the calendar table I only have changes at the time it happens.
So I cannot have the on hand stock daily.
My file is 300 mega I don't think I can share it 🙂 but I can for sure provide more details 🤠
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |