topic Re: Dynamic opening stocks in DAX Commands and Tips

Dynamic opening stocks

punnas1 — Tue, 31 Mar 2020 05:43:47 GMT

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

Re: Dynamic opening stocks

Anonymous — Tue, 31 Mar 2020 07:33:29 GMT

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

Re: Dynamic opening stocks

Anonymous — Tue, 31 Mar 2020 09:29:50 GMT

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