Compara Actual data AND historical data, modeling problem

[SebSchoon1]

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 

Images de stock = CALCULATE(SUMX('Lignes de mouvement (img stock)','Lignes de mouvement (img stock)'[QUANTITE]),'Calendrier'[Date]<=max('Calendrier'[Date]))

But i'd like to have the [Collection] from the "Lignes de mouvement (img Stock) Value calculated.

because in the table "Base article" it is the last updated values. Which propagate to my lignes de mouvement (img stock)

due to relation.

any way to consolitate data?

Kind regards!

[VijayP]

@SebSchoon1 

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!

[SebSchoon1]

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 🤠