Filling Last NonBlank Available Balance for dates with no transactions

[RamiSomar]

I've recently started to use DAX, I need your help for DAX function to get below disired table. 

Current table linked to calander table, Current table is simply presenting daily closing balance for 4 bank accounts with four differecne currenies. Missing dates are supposed to have last available balance. 

Thanks in Advance. 

[lbendlin]

please provide the sample data in usable format (paste as table or attach).

[RamiSomar]

https://1drv.ms/u/s!AkjE4AolTiMktDtsjF8lCsvSCu-k?e=QNxEEA

[lbendlin · Accepted solution]

Bal = 
var d = SELECTEDVALUE(Calendar_Table[Date])
return 0+CALCULATE(
    LASTNONBLANKVALUE(
        Calendar_Table[Date],sum('Historical MT940'[Closing Balance])
    )
    ,Calendar_Table[Date]<=d
)

Also set your Calendar_Table[Date] field to "Show items with no data".

[RamiSomar]

Many thanks, it works perfectly.