Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Cumulative Count Column by Group

Hi there!   I am trying to implement a column like so:   animal count cat 1 dog 1 mouse 1 cat 2 dog 2 mouse 2 cat 3 mouse 3 cat 4 dog 3 mouse 4 ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

    Hi

     

    First add an Index Column from the Query Editor

     

    Then you can RANK based on that Index to get the desired calcualted column

    i.e

     

    Count =
RANKX (
    FILTER ( Table1, Table1[animal] = EARLIER ( Table1[animal] ) ),
    [Index],
    ,
    ASC
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Anonymous

 

Hi

 

First add an Index Column from the Query Editor

 

Then you can RANK based on that Index to get the desired calcualted column

i.e

 

Count =
RANKX (
    FILTER ( Table1, Table1[animal] = EARLIER ( Table1[animal] ) ),
    [Index],
    ,
    ASC
)