Running balance carry over monthly

[r0ot5]

Hi All,

I'm trying to get a measure that will display the running balance carried over from previous month.

So here's what I'm tryin to do (C+D-E) will give me F as my closing balance then next month I carry over that closing balance and start again.

Thanks,

Marc

[amitchandak · Accepted solution]

@r0ot5 , Assuming you have a date you can get like this

Closing Balance = CALCULATE(Table([Purcahse])-SUM(Table[Sales]),filter(allselected(Table),Table[date] <=max(Table[Date])))

[r0ot5]

Thanks for help, that's exactly what I needed :).