Forum Discussion

s_namon's avatar
s_namon
New Member
7 years ago

How to sum value in next column

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

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    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