Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
5 years ago

Calculating difference per rows in different columns in Power BI

Hello,

 

I have issue calculating the difference between different column values in same table. The result in a new created column is wrong.

My data input table is here:

My output result is:

But expected result is:

Seems wrong answers because 0.87!=-3289.13

So how solve this issue?

 

My query is here:

Seems something wrong with my query.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI Analitika,

    You can try to use the following calculated column formulas if it helps:

    column =
VAR NextDate =
    CALCULATE (
        MIN ( Table[Date] ),
        FILTER (
            Table,
            [ID] = EARLIER ( Table[ID] )
                && [OBJ_ID] = EARLIER ( Table[OBJ_ID] )
                && [Date] > EARLIER ( Table[Date] )
        )
    )
VAR CRE =
    CALCULATE (
        MAX ( Table[CRE] ),
        FILTER (
            Table,
            [ID] = EARLIER ( Table[ID] )
                && [OBJ_ID] = EARLIER ( Table[OBJ_ID] )
                && [Date] = NextDate
        )
    )
RETURN
    IF ( [DEF] <> 0, CRE - [DET] )

    Regards,
    Xiaoxin Sheng