Forum Discussion

Dennis_Pedersen's avatar
Dennis_Pedersen
Icon for Helper I rankHelper I
7 years ago

FIFO Stock

Hi    Have been looking at some posts and cannot find the solution for this. I have a purchase fact table like below If the UnitsInStock is 800, I need a DAX measure for calculation Qty_Stock like...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Please formulate your question in a very clear fashion so that everyone (not only you) can understand it. Then maybe someone will be able to help you.

 

Thanks.

 

Best

Darek

  • Dennis_Pedersen's avatar
    Dennis_Pedersen
    Icon for Helper I rankHelper I
    7 years ago

    Okay - if I for example have chosen today(from DIM_time) the UnitsInStock measure may give me a figure of 800 pcs. in Stock.

     

    I would like to split this figure into 3 purchases according to my fact Purchase table like the column at the right.

    Is that possible?