Solved: Dynamic opening stocks

punnas1 · ‎03-30-2020

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 · ‎03-31-2020

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

View solution in original post

Anonymous · ‎03-31-2020

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 · ‎03-31-2020

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