Forum Discussion

punnas1's avatar
punnas1
Helper II
6 years ago
Solved

Dynamic opening stocks

Hi All,

 

Only current month Opening stocks values shold be from stock table and subsequent months Opening stock should be same as privious month closing stocks values.

Pls help with Dax formula.

 

 

Regards,

Suresh

DAX

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    What do you mean by "current month"? In each cell the current month is different. You probably mean the very first month in the set of visible months, right?

    Best
    D
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Not sure if this is what you wanted... but you could have a look and adjust it to your needs.

     

    Please see the file attached.

     

    Best

    D