Dynamic opening stocks

[punnas1]

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

[Anonymous · Accepted solution]

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

[Anonymous]

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