Hi, how can i achieve this in my visual? I cannot add the add column starting with 1 for this since that will be static. I need the row numbers for the visual so that it changes dynamically.
Go to Solution.
You can add a index column in Power Query which will have unique value and then use above logic based on index value.
View solution in original post
rownum = CALCULATE(COUNTROWS(Table1),FILTER(ALLSELECTED(Table1),Table1[Name]<=MAX(Table1[Name])))
Is this what you are looking for?
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!