Forum Discussion

comish4lif's avatar
comish4lif
Helper II
8 years ago
Solved

Cumulative Count by Date

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 Creat...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    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] )
    )
)
Toslo's avatar
Toslo
New Member
4 years ago

In regard to the topic above. I used the solution to get a measure for the count in every category, but I get no values for dates when their is no "activity" on a category. It wil only cumulatively count the rows when there is a value in that year. Example 2018 "109", 2019 "" and 2020 "121". Does anybody know how to solve this issue?