DAX Cashflow Customized weekly calculation

[Jiji0129]

 Hi Team - I hope you could help me with this one. I am working on a Cashflow dashboard that has this Scenario Below:
Opening Cash: $-386,102.68
Shortfall (Weekly): week1 $785,409, week2 $342, week3 $534...etc...
Cash End of Week: FirstWeek = Open Cash + Shortfall (Week1) so like $-386,102.68 + $785,409 = $399,307. My problem is how to go on week 2 onwards where I could customize the calculation to = Cash End of Week (Week1) 399,307 + Shortfall Week2 $545,893 and so on and so fort.  

[daXtreme]

Hi there.

I don't think this can be answered properly without knowing the underlying data structure. Excel is very different from Power BI, so there's no immediate port from Excel formulas to PBI. Sorry 😞