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

Question

Hello,&nbsp;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 difference by values in same row.Here is my data table example:My expected result is:My output result is:&nbsp;Seems that result is wrong. I expected to 0.87 but I am&nbsp; getting -3289,13. So what's wrong here in my DAX fomula?My query is here:Column = VAR _0 = MINX(FILTER('DBA view_DidknObj','DBA view_DidknObj'[DID_DAT]&gt; EARLIER('DBA view_DidknObj'[DID_DAT]) &amp;&amp; 'DBA view_DidknObj'[SAS_KOD]= EARLIER('DBA view_DidknObj'[SAS_KOD])),[DID_DAT])VAR _1 = MAXX(FILTER('DBA view_DidknObj','DBA view_DidknObj'[DID_DAT] =_0 &amp;&amp; 'DBA view_DidknObj'[SAS_KOD]= EARLIER('DBA view_DidknObj'[SAS_KOD]) ),[SUM_CRE])returnif('DBA view_DidknObj'[SAS_KOD] &lt;&gt; 0,_1 - 'DBA view_DidknObj'[SUM_DEB], blank())&nbsp;

amitchandak · Answer

Analitika , Try these 
&nbsp;
Calc 1 = var _1 = maxx(FILTER('Table', [ID] =EARLIER('Table'[ID]) &amp;&amp; [CRE]&lt;&gt;0) ,[CRE])return if([DET] &lt;&gt;0, _1 -[DET])
or
Calc 12 = var _1 = maxx(FILTER('Table', [ID] =EARLIER('Table'[ID]) &amp;&amp; [CRE]&lt;&gt;0 &amp;&amp; [DATE] &gt;EARLIER('Table'[DATE]) ) ,[CRE])return if([DET] &lt;&gt;0, _1 -[DET])

analitika · Answer

amitchandak&nbsp;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 · Answer

Hello having errorCalc 1 = var _1 = maxx(FILTER('DBA view_DidknObj', [SAS_KOD] =EARLIER('DBA view_DidknObj'[SAS_KOD]) &amp;&amp; [SUM_CRE]&lt;&gt;0) ,[SUM_CRE] &amp;&amp; FILTER('DBA view_DidknObj','DBA view_DidknObj'[id] in {20210}))return if([SUM_DEB] &lt;&gt;0, _1 -[SUM_DEB])&nbsp;&nbsp;&nbsp;

v-lianl-msft · Answer

Unfortunately, I don't know your calculation logic. The fields in your formula are inconsistent with the sample data you provided, so it's difficult to correctly express what you mean. Please provide a pbix file after deleting sensitive data and the calculation logic you want to implement.