rolling sum

  1. A

    Rolling Hour Sum in DAX

    Hello Friends, I need some help finding a DAX solution to a solved Excel problem in the link below. https://1drv.ms/x/s!AuhgWIfRbRU2oXSl2z7NPx8Q9YjR Essentially I need a rolling sum that calculates a row count for all rows that exist within 1 hour of the original time. (Ideally, being able to...
    • Alex8112
    • Thread
    • dax excel to dax rolling rolling sum time
    • Replies: 0
    • Forum: Power Tools
  2. B

    Ad an amount weekly

    Hi I am trying to add a rent amount to a total on a weekly basis. I have a dashboard that is used by the boss and he wants to have it updated weekly. Is there a formula that can automatically reference an amount cell and add that amount to the total on a weekly basis. Say every Monday. Thank you...
  3. E

    Calculating a rolling sum in Excel 2007

    Hi, I'm new to the Excel board, but I'm hoping you guys can help me out. I need to find a way to calculate employees' sales for the last 3 months on a rolling basis. I think I want a function that looks for the column that matches "current month," offsets by -2 columns, and then sums from...
    • Elle G
    • Thread
    • index function match function offset function rolling sum
    • Replies: 3
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top