Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🤠
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
142 | |
104 | |
104 | |
80 | |
66 |