Forum Discussion

Jiji0129's avatar
Jiji0129
New Member
4 years ago

DAX Cashflow Customized weekly calculation

 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.  

 

1 Reply

  • daXtreme's avatar
    daXtreme
    Icon for Solution Sage rankSolution Sage
    4 years ago

    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 😞