Forum Discussion

emmabrice's avatar
emmabrice
Frequent Visitor
7 years ago
Solved

Cash Flow statement

Hi  Hoping that someone can help me with forecasting cash flow into the future. I have tables a lot like this previous post https://community.powerbi.com/t5/Desktop/Generating-CashFlow-Forecast-T...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    7 years ago

    You might try:
    Quarter Totals = SUMX(SUMMARIZE(tableformonth_year, table[month_year], "quarter totals", [Monthly Drawdown]), [quarter totals]))

PaulDBrown's avatar
PaulDBrown
Community Champion
7 years ago

You might try:
Quarter Totals = SUMX(SUMMARIZE(tableformonth_year, table[month_year], "quarter totals", [Monthly Drawdown]), [quarter totals]))