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 project...
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
)
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!