Desktop

[ppgandhi11]

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.

[rajendran · Accepted solution]

You can add a index column in Power Query which will have unique value and then use above logic based on index value.

Thanks
Raj

[rajendran]

Try this

rownum = CALCULATE(COUNTROWS(Table1),FILTER(ALLSELECTED(Table1),Table1[Name]<=MAX(Table1[Name])))

Thanks

Raj

[ppgandhi11]

I tried this already (got it from other post). It does not work in my case because I don’t have unique ID/name . It repeated. So if ID 1 has name abc repeated twice I will see 2,2 as row number for them instead of 1,2. Makes sense?

[mnayar]

Is this what you are looking for?

https://community.powerbi.com/t5/Desktop/How-to-add-a-Serial-Number-or-Row-Number-Column-in-Power-BI...

[rajendran · Accepted solution]

You can add a index column in Power Query which will have unique value and then use above logic based on index value.

Thanks
Raj

[ppgandhi11]

Yep. It works that way! Thanks!