Previous Balance Calculation Issue

Hi Rahulsingh,

Based on my test, you could refer to below steps:

Sample data:

Create two measures:

Index = RANKX(ALL(Table1),FIRSTNONBLANK('Table1'[Dates],'Table1'[Dates]),,ASC,Dense)

Measure = var a=[Index]-1
return CALCULATE(SUM(Table1[Balance]),FILTER(ALL('Table1'),'Table1'[Index]=a))

Result:

 You could also download the pbix file to have a view:

https://www.dropbox.com/s/vgkl8c3yf5vccn0/Previous%20Balance%20Calculation%20Issue.pbix?dl=0

Regards,

Daniel He

 Thank you v-danhe-msft it worked. Thanks a lot