Forum Discussion

timo980111's avatar
timo980111
Frequent Visitor
3 years ago

Stock level Calculation

Hi guys, I'm new at DAX, but I can't find any solution that fits for my problem.  Maybe one of you can help me.  I would like to calculate my future stock level based on the following table. ...
timo980111's avatar
timo980111
Frequent Visitor
3 years ago

Unfortunately it's not working - Just to clarify I need the following formular as DAX:

Example for index31 -> stock31 = index29stock + Delta29 + Delta30 + Delta31.

Example for index32 -> stock32 = index29stock + Delta29 + Delta30 + Delta31.

v-easonf-msft's avatar
v-easonf-msft
Community Support
3 years ago

Hi， timo980111 

Please try formula like:

Measure1 =
VAR stock29 =
    CALCULATE ( [M_stock], FILTER ( Table1, Table1[Index] = 29 ) )
RETURN
    SUMX (
        FILTER (
            ALL ( Table1 ),
            Table1[Index] <= MAX ( Table1[Index] )
                && Table1[Index] >= 29
        ),
        [M_DELTA]
    ) + stock29

Best Regards,
Community Support Team _ Eason