Forum Discussion

SebSchoon1's avatar
SebSchoon1
Post Patron
3 years ago

Compara Actual data AND historical data, modeling problem

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!
 

 

 

Need Help

2 Replies

  • VijayP's avatar
    VijayP
    Community Champion
    3 years ago

    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's avatar
      SebSchoon1
      Post Patron
      3 years ago

      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 ğŸ¤