Can anyone help me with this.?
I need make the calculated column on the right hand side that only increments when the original field changes its value.
Noticed that the increments should keep increasing even though the a original group value may repeat the index should not.
Is there an option or some dax etc to achieve this?
Solved! Go to Solution.
@fraza
This is logically not possible since you don't have a field to group by. As the workaround, you could add an index column and flag column before getting the rank, which is a bit confusing.
1. add an index column in power query
2. create a flag column
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@fraza
This is logically not possible since you don't have a field to group by. As the workaround, you could add an index column and flag column before getting the rank, which is a bit confusing.
1. add an index column in power query
2. create a flag column
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
122 | |
62 | |
56 | |
47 | |
42 |
User | Count |
---|---|
113 | |
65 | |
61 | |
54 | |
46 |