How add a value from last result with another column with condition

[ILANGO_10]

 in this problem I need a needed column if seq no is 0 then add a previous value of needed with the value of quantity.. I hope you  can understand my problem... If you can't please see the picture there is Excel formula to got understand the problem... Please help me to find out the solution...

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

needed CC =
VAR _serialno = Data[serial no]
VAR _lastnonzeroseqnoserialno =
    MAXX (
        FILTER ( Data, Data[serial no] <= _serialno && Data[seq no] <> 0 ),
        Data[serial no]
    )
RETURN
    IF (
        Data[seq no] <> 0,
        Data[seq no],
        MAXX (
            FILTER ( Data, Data[serial no] = _lastnonzeroseqnoserialno ),
            Data[seq no]
        )
            + SUMX (
                FILTER (
                    Data,
                    Data[serial no] > _lastnonzeroseqnoserialno
                        && Data[serial no] <= _serialno
                ),
                Data[quantity]
            )
    )