Previous Row Value for First Line

[Anonymous]

Hi, 

I need help with the following. Currently, the first line of my output for 'New Column' is not the result I wanted. First line should be 'Current Balance' (-335.00) - 'Amount' (-235.00). How do I add this in my current script?

Current Script:

New Column =

VAR PreviousRow =

TOPN (

1,

FILTER ( Table, Table[Date ] < EARLIER ( Table[Date ] ) ), [Date ], ASC)

VAR PreviousValue =

MINX ( PreviousRow, Table[ Amount] )

RETURN

Table[ Amount] + PreviousValue

Current Output:

Customer	No	Type	Date	Amount	Current Balance	New Column
BI111	2300000008	Customer Payment	4/2/2019	-235.00	-335.00	-235.00
BI111	1200000019	SD-Billing Document	4/6/2019	251.00		-351.00
BI111	1200000030	SD-Billing Document	4/12/2019	203.00		-554.00
BI111	1200000051	SD-Billing Document	4/20/2019	93.00		-647.00
BI111	2300000040	Customer Payment	4/24/2019	-279.00		-368.00
BI111	2300000041	Customer Payment	4/24/2019	-504.00		136.00
BI111	1200000076	SD-Billing Document	4/26/2019	76.00		60.00
BI111	2300000087	Customer Credit	4/30/2019	-10.00		70.00
BI111	2300000088	Customer Credit	4/30/2019	-17.00		87.00

Desired Output:

Customer	No	Type	Date	Amount	Current Balance	New Column
BI111	2300000008	Customer Payment	4/2/2019	-235.00	-335.00	-100.00
BI111	1200000019	SD-Billing Document	4/6/2019	251.00		-351.00
BI111	1200000030	SD-Billing Document	4/12/2019	203.00		-554.00
BI111	1200000051	SD-Billing Document	4/20/2019	93.00		-647.00
BI111	2300000040	Customer Payment	4/24/2019	-279.00		-368.00
BI111	2300000041	Customer Payment	4/24/2019	-504.00		136.00
BI111	1200000076	SD-Billing Document	4/26/2019	76.00		60.00
BI111	2300000087	Customer Credit	4/30/2019	-10.00		70.00
BI111	2300000088	Customer Credit	4/30/2019	-17.00		87.00

[amitchandak · Accepted solution]

@Anonymous , refer if the file attached after signature can help.

Created two-column. Check those