Calculate difference of values per different rows and columns in Power BI

[Analitika]

Hello,

I am having wrong calculation on calculating the difference between values which are in different columns and rows.

My sample data:

My query:

My output:

That output is wrong because differnce contains wrong value: -3289.13 not equal 0.87 (3290-3289.13=0.87).

Something wrong with my query, how I could solve it?

[Icey · Accepted solution]

Hi @Analitika ,

Please try this:

Column 2 =
VAR PreCRE =
    CALCULATE (
        SUM ( 'Table'[CRE] ),
        FILTER (
            'Table',
            'Table'[ID] = EARLIER ( 'Table'[ID] )
                && 'Table'[OBJ_ID] = EARLIER ( 'Table'[OBJ_ID] )
                && 'Table'[DATE] > EARLIER ( 'Table'[DATE] )
        )
    )
RETURN
    IF ( 'Table'[DET] <> BLANK (), PreCRE - 'Table'[DET] )

Best Regards,

Icey

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