Refer to multiple column values

Hi Phellipe 

For your question, here is the method I provided:

Here's some dummy data

"Table"

First, add the index column in “Transform data”

Click Close & Apply.

Create a measure. Add extra columns to balance negative numbers - currently SQL SRV 2018 Ent Core 2017's rows have "-186", the new output should be 0, SQL SRV 2022 Ent Core's rows should be 186 less (760-186).

New_Delta = 
    var _delta = IF(
        SELECTEDVALUE('Table'[Delta]) <> SELECTEDVALUE('Table'[Entitlements]), 
        VALUES('Table'[Delta]), 
        CALCULATE(
            ABS(MIN('Table'[Delta])), 
            FILTER(
                ALL('Table'), 
                'Table'[Index] = MAX('Table'[Index]) -1
            )
        )
    )
RETURN 
    IF(
        SELECTEDVALUE('Table'[Delta]) > 0 
        && 
        SELECTEDVALUE('Table'[Delta]) <> SELECTEDVALUE('Table'[Entitlements]), 
        VALUES('Table'[Delta]), 
        SELECTEDVALUE('Table'[Delta]) - _delta
    )

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.