Forum Discussion
Create Index on a table in Data pane and not in Power Query
Hi, I have created a simple list of String using the Create Table in Data pane. I wanted to create a column that shows the row number. I came accros RankX but that sorts using the string and assig...
Fowmy
Super User
Super UserJacoMathew
I doubt you can have a number sequence without associating it to an existing column or columns. What stops you from creating a table in Power Query and adding an Index Column.?
I know it can be done with Power Query. I wanted to know if it can be done from the Data pane. Thought I was missing something simple. Has happened to me in the past. I guess for now, I will move the table creation to Power Query.
I used switch expression for another table but that had only 5 items.
- Fowmy
JacoMathew
Yes, that's the right approach
