Reply
Regular Visitor
Posts: 37
Registered: ‎11-01-2017
Accepted Solution

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

@comish4lif,

 

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.

View solution in original post


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

Re: Cumulative Count by Date

Hi @comish4lif

 

Could you maybe show an example of what you mean?  


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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

Re: Cumulative Count by Date

[ Edited ]

Cumulative.png

 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.

NotCumulative.png

 

 

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

Re: Cumulative Count by Date

@comish4lif,

 

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.