Forum Discussion
Compara Actual data AND historical data, modeling problem
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!
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 ðŸ¤