I want Dax measure to solve this case!!!

[LB-Tech]

I have a input table like this 
i need a output column (i.e Output Amount ) I need a Dax measure to solve this scenerio
the table attached below is the explanation table to fetch my desired output.

[LB-Tech]

Hi @MFelix 
Thankyou for you DAX it worked well for Remaining Total Column, But my desired output is the last column (Output Amount Column) Could you guide me for the Output Column.

[MFelix]

Hi @LB-Tech ,

Apologies for the incorrection change the measure Remaininig Total and add a new one:

Remaining Total = 
        VAR _totalCredit = CALCULATE(
			[Credit Total],
			ALL('Table'[Date])
		)
		VAR _Remaining = _totalCredit - CALCULATE(
			[Debit Total],
			'Table'[Date] <= MAX('Table'[Date])
        )
     Return
			
            _Remaining


Output Amount = 
        VAR _PreviousRemaining = SUMX(
			TOPN(
				1,
				FILTER(
					ALL('Table'[Date]),
					'Table'[Date] < MAX('Table'[Date])
				),
				'Table'[Date],
				DESC
			),
			[Remaining Total]
		)
		RETURN
			SWITCH(
				TRUE(),
				_PreviousRemaining = BLANK(), [Debit Total] - [Debit Total],
				_PreviousRemaining > [Debit Total], [Debit Total] - MIN(
					[Debit Total],
					_PreviousRemaining
				),
				_PreviousRemaining > 0, [Debit Total] - MAX(
					_PreviousRemaining,
					0
				),
				[Debit Total] - 0
			)

[LB-Tech]

Hi @MFelix 
The first Remaining Total Measure got right, but I am not getting the output amount measure 
But still figured out the required output by different measure.
Thankyou for your help.

[MFelix]

Hi @LB-Tech ,

There isn't enough information to get the values that you need, the first one I see is on the first row were you do a calculation 72.200 - 59.000. Where are the 72.200 coming from?

Also can you please share some mockup file and a litle bit more context in terms of semantic model?

[LB-Tech]

72200 is the total of the credit side. i have n no of party's, and they have debit and credit column. i need to take the total of the credit side of a party and set off against the debit column by date order. Then my output should be output column where i need the balance of debit amount date wise after setting off the credit total.

[MFelix · Accepted solution]

Hi @LB-Tech ,

Try to create the following measures:

Credit Total = SUM('Table'[Credit])

Debit Total = SUM('Table'[Debit])

Remaining Total = 
        VAR _totalCredit = CALCULATE(
			[Credit Total],
			ALL('Table'[Date])
		)
		VAR _Remaining = _totalCredit - CALCULATE(
			[Debit Total],
			'Table'[Date] <= MAX('Table'[Date])
		)
		RETURN
			IF(
				_Remaining > 0,
				_Remaining,
				0
			)