Cumulative Total for periods less than a day

[zgiszag]

Hi All,

I'm having trouble with calculating running totals on units less than a day.

<

Aboveis what I want to count over 10 minute intervals.

So what I did was group the time column in bins of 10 minutes and then did a quick measure for running total on Completes by Time (10 mins)

For some reason it isn't counting any results in bins that end with 59 seconds hence I get an incorrect total of 13. I've tried following this guide (https://www.daxpatterns.com/cumulative-total/) however I can't create a calendar table for 10 minute intervals.

Can anyone give me any pointers as to how I should go about this?

Thanks

[v-danhe-msft]

Hi @zgiszag ,

What is your desired result? If the interval is <10 minutes, the [Completes] should not be added? So your running total shoud show as below?

1
2
4
5
7
8
8（8+0）
11（8+3）
13（11+2）
...
...

Hope you could offer me more information.

Regards,

Daniel He

[zgiszag]

Ths issue was that I needed a cumulative total for each 10 minutes passed. Here is what I want according to the data I screenshotted

(time, completes, running total of completes)

1:20 1 1

1:30 1 2 (1+1)

1:40 2 4 (2+2)

1:50 1 5 (4+1)

2:00 2 7 (5+2)

2:10 1 8

2:20 1 9

2:30 3 12

2:40 2 14

2:50 1 15

For some reason I can't get the intervals to be exactly 10 minutes. It doesn't count the intervals that are less than 10 minutes. That's what I've highlighted in the screenshot.

Thanks for your help!

[v-danhe-msft · Accepted solution]

Hi @zgiszag ,

Could you have just tried below measure with your data:

Measure = CALCULATE(SUM(Table1[Completes]),FILTER(ALL(Table1),'Table1'[Time]<=MAX('Table1'[Time])))

You could also download the pbix file to have a view.

Regards,

Daniel He