Forum Discussion
JacoMathew
4 years agoFrequent Visitor
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...
JacoMathew
4 years agoFrequent Visitor
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
Super User
4 years agoJacoMathew
Yes, that's the right approach