Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |