Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Compounding Monthly Total in Graph

Hello,   I am trying to create a graph that shows a lagging 365 days of transactions by month, but with each month adding into the following month. IE: If the data shows "Month 1=5K, Month 2=4K, Mo...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Solved, see below.

     

    Cumulative Transactions = CALCULATE(SUM((Sheet1[Transaction])),FILTER(ALLSELECTED(Sheet1),Sheet1[Transaction Complete Date] <= MAX(Sheet1[Transaction Complete Date])))

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Solved, see below.

 

Cumulative Transactions = CALCULATE(SUM((Sheet1[Transaction])),FILTER(ALLSELECTED(Sheet1),Sheet1[Transaction Complete Date] <= MAX(Sheet1[Transaction Complete Date])))