## Desktop

Regular Visitor
Posts: 37
Registered: ‎11-01-2017

# Cumulative Count by Date

[ Edited ]

I have looked at 47 different formula posted here and cannot figure this out.

I have a Sharepoint list that tracks workflow items and I am trying to create a Cumulative Monthly count by the Created Date.

```Requests Created Cumulative =
CALCULATE(
COUNT('Production Approval Workflow'[RowNumber]),
FILTER(
'Production Approval Workflow',
('Production Approval Workflow'[Created].[MonthNo] <= MAX ('CalendarTable'[Date]) )
)
)```

This code above will return the correct cumulative total for all time. What do I need to add to get this measure to display a monthly cumulative total for each month?

Accepted Solutions
Community Support Team
Posts: 4,024
Registered: ‎07-09-2016

## Re: Cumulative Count by Date

You may refer to measure below.

```Measure =
CALCULATE (
COUNT ( 'Production Approval Workflow'[RowNumber] ),
FILTER (
ALLSELECTED ( 'Production Approval Workflow' ),
'Production Approval Workflow'[Created] <= MAX ( 'CalendarTable'[Date] )
)
)
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

All Replies
Super User
Posts: 2,618
Registered: ‎11-29-2015

## Re: Cumulative Count by Date

Could you maybe show an example of what you mean?

Proud to be a Datanaut!

Regular Visitor
Posts: 37
Registered: ‎11-01-2017

## Re: Cumulative Count by Date

[ Edited ]

The picture above is how I want the calculation to show a monthly total.

Below is how it is not displaying the monthly total, and is only showing the complete total.

Community Support Team
Posts: 4,024
Registered: ‎07-09-2016

## Re: Cumulative Count by Date

You may refer to measure below.

```Measure =
CALCULATE (
COUNT ( 'Production Approval Workflow'[RowNumber] ),
FILTER (
ALLSELECTED ( 'Production Approval Workflow' ),
'Production Approval Workflow'[Created] <= MAX ( 'CalendarTable'[Date] )
)
)
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.