Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |