Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Cumulative Count for Order/Index

Hey guys, how are you?

 

I'm struggling to try to calculate a cumulative sum in a table, in order to create a sort of index or order for projects.

 

Let's say I have a database related to projects where any change I made to the project, a new key is generated related to that project.

So the structure is like:

https://i.imgur.com/7nO9ic6.jpg

The Project Code field could be repeated as many times as possible and the KEY field is a register in de database which creates a new one every time a change is made to the project, so KEY could not be repeated.

 

What I need to do is to create a CUMULATIVE COUNT of the Key column, for every Project Code.

 

Thank you!

 

 

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous

     

    You can use a calculated column like

     

    Index =
RANKX (
    FILTER ( Table1, [Project Code] = EARLIER ( [Project Code] ) ),
    [Key],
    ,
    ASC,
    DENSE
)

3 Replies

  • richbenmintz's avatar
    richbenmintz
    Resident Rockstar
    7 years ago

    Hi Anonymous

    can you provide a sample data model and what the expected output would look like?

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      7 years ago

      Anonymous

       

      You can use a calculated column like

       

      Index =
RANKX (
    FILTER ( Table1, [Project Code] = EARLIER ( [Project Code] ) ),
    [Key],
    ,
    ASC,
    DENSE
)
      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        THANK YOU! I didn't know the RANKX function!

        All I have learned is from Youtube and self-working.

         

        Thank you!