Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 🤠
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |