Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
4 years ago

How to calculate difference between different rows and columns in the same table in Power BI?

Hello,   I am trying to calculate the difference between values which are in different rows and columns. When I am trying to calculate I am getting a wrong result. Seems my query calculates differe...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Analitika , Try these

 

Calc 1 =
var _1 = maxx(FILTER('Table', [ID] =EARLIER('Table'[ID]) && [CRE]<>0) ,[CRE])
return if([DET] <>0, _1 -[DET])

or


Calc 12 =
var _1 = maxx(FILTER('Table', [ID] =EARLIER('Table'[ID]) && [CRE]<>0 && [DATE] >EARLIER('Table'[DATE]) ) ,[CRE])
return if([DET] <>0, _1 -[DET])

  • Analitika's avatar
    Analitika
    Post Prodigy
    4 years ago

    amitchandak Yes I have tried but is possible to include filter Id like id=500 because there are more rows in data? In the same query I mean.

  • Analitika's avatar
    Analitika
    Post Prodigy
    4 years ago

    Hello having error

    Calc 1 =
    var _1 = maxx(FILTER('DBA view_DidknObj', [SAS_KOD] =EARLIER('DBA view_DidknObj'[SAS_KOD]) && [SUM_CRE]<>0) ,[SUM_CRE] && FILTER('DBA view_DidknObj','DBA view_DidknObj'[id] in {20210}))
    return if([SUM_DEB] <>0, _1 -[SUM_DEB])