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, Month 3=6K" I would want it to show "Month 1=5K, Month 2=9K, Month 3=15K" etc.  The issue I have is that my data is thousands of individaul transaction (with time stamps down to the minutes) and I would like to still be able to drill up and down if need be rather than locking it in with stagnant number. Below is an example of my data set.  Currently at 33K lines.  Would like this to be something I can refresh regualrly if possible.

 

TransctionTransaction Complete DateMonth
$6,001.8611/13/2018 4:56:00 PMNov-18
$800.445/10/2019 4:41:00 AMMay-19
$4,107.7211/29/2018 1:00:00 PMNov-18
$4,107.7212/13/2018 5:05:00 PMDec-18
$4,107.7212/7/2018 11:54:00 PMDec-18
$4,107.721/10/2019 2:34:00 PMJan-19
$4,107.722/2/2019 3:20:00 AMFeb-19
$724.9412/18/2018 8:59:00 AMDec-18
$1,789.728/27/2018 2:23:00 AMAug-18
$447.438/29/2018 4:19:00 AMAug-18
$447.4310/30/2018 3:12:00 PMOct-18
$894.8612/31/2018 3:22:00 PMDec-18
$1,789.7212/5/2018 10:22:00 AMDec-18
$1,789.7212/9/2018 10:00:00 AMDec-18
$894.861/17/2019 10:05:00 AMJan-19
$1,342.293/27/2019 6:26:00 PMMar-19
$447.439/21/2018 11:51:00 AMSep-18
$9,004.648/26/2018 5:14:00 AMAug-18
$9,004.641/12/2019 8:34:00 PMJan-19
$9,004.641/28/2019 11:36:00 AMJan-19
$9,004.642/4/2019 10:49:00 AMFeb-19
$18,009.283/24/2019 5:10:00 PMMar-19
$9,004.644/2/2019 11:30:00 AMApr-19
$9,728.9110/23/2018 6:12:00 AMOct-18
$9,728.9111/3/2018 4:39:00 AMNov-18
$9,728.911/12/2019 8:34:00 PMJan-19
$9,728.911/28/2019 11:36:00 AMJan-19
$9,728.912/25/2019 6:19:00 PMFeb-19
$764.041/21/2019 4:23:00 PMJan-19
$764.042/27/2019 4:58:00 PMFeb-19
$764.047/12/2018 7:28:00 PMJul-18
$4,139.9710/22/2018 5:54:00 PMOct-18
$4,139.971/31/2019 12:41:00 PMJan-19
$4,139.972/27/2019 7:41:00 AMFeb-19
$4,139.975/9/2019 6:58:00 PMMay-19
$3,326.261/29/2019 12:58:00 AMJan-19
$292.008/10/2018 5:07:00 AMAug-18
$153.319/13/2018 9:48:00 AMSep-18
$153.319/28/2018 9:58:00 AMSep-18
$315.2110/8/2018 3:15:00 PMOct-18
$495.332/3/2019 7:34:00 PMFeb-19
$166.3811/12/2018 10:36:00 AMNov-18
$8,306.608/27/2018 12:35:00 PMAug-18
$8,306.6010/18/2018 10:39:00 PMOct-18
$16,613.2012/19/2018 4:23:00 PMDec-18
$16,613.201/3/2019 5:44:00 PMJan-19

 

Any support would be greatly appreciated.

 

Thanks,

 

Turner

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])))

2 Replies

  • 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])))