Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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!

 

 

1 ACCEPTED SOLUTION

@Anonymous

 

You can use a calculated column like

 

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

Regards
Zubair

Please try my custom visuals

View solution in original post

3 REPLIES 3
richbenmintz
Solution Sage
Solution Sage

Hi @Anonymous

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



I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!


@Anonymous

 

You can use a calculated column like

 

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

Regards
Zubair

Please try my custom visuals
Anonymous
Not applicable

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

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

 

Thank you!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.