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 |
---|---|
137 | |
59 | |
58 | |
55 | |
48 |
User | Count |
---|---|
126 | |
74 | |
56 | |
52 | |
49 |