How to sum value in next column

[s_namon]

I want to calculate about how long that initial order will be ran out of stock

and this is sample of current data (M is sales of each month),

column "Month" is total month until stock ran out (I need this column)

Can i set formula as a VAR or not? Please help

[Anonymous]

Hi there.

Very bad design, mate. I wouldn't even try to work with such a Frankenstein. Please, try to learn a bit about a proper design (there are tons of materials on YT about it) and your DAX will become very straightforward and simple.

Best
Darek