Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills 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?
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 TeamIf this post helps, please Accept it as the solution to help the other members find it more quickly.
View solution in original post
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.