Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
@Anonymous
You can use a calculated column like
Index = RANKX ( FILTER ( Table1, [Project Code] = EARLIER ( [Project Code] ) ), [Key], , ASC, DENSE )
Hi @Anonymous
can you provide a sample data model and what the expected output would look like?
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 )
THANK YOU! I didn't know the RANKX function!
All I have learned is from Youtube and self-working.
Thank you!
User | Count |
---|---|
102 | |
91 | |
85 | |
77 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |