Forum Discussion

pmcard97's avatar
pmcard97
New Member
8 years ago
Solved

Cumulative Transaction Count

I have a table of transactions with a transaction date.  I want to create a line graph that displays the cumulative count of transactions.   I created a new column as:     Cumulative Count = CAL...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    pmcard97

     

    Hi,

     

    If you are using a calculated column, you need to replace "Max" with "Earlier"

    =
CALCULATE (
    COUNTROWS ( master_roster ),
    FILTER (
        master_roster,
        master_roster[enrollmentDate] <= EARLIER ( master_roster[enrollmentDate] )
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

pmcard97

 

Hi,

 

If you are using a calculated column, you need to replace "Max" with "Earlier"

=
CALCULATE (
    COUNTROWS ( master_roster ),
    FILTER (
        master_roster,
        master_roster[enrollmentDate] <= EARLIER ( master_roster[enrollmentDate] )
    )
)