topic Calculating difference per rows in different columns in Power BI in DAX Commands and Tips

Calculating difference per rows in different columns in Power BI

Analitika — Thu, 14 Oct 2021 07:28:02 GMT

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.

Re: Calculating difference per rows in different columns in Power BI

Anonymous — Mon, 18 Oct 2021 01:31:58 GMT

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