Forum Discussion

Frequent Visitor

4 years ago

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...

Need Help

PaulDBrown

Community Champion

4 years ago

You could create it using a veeeery long SWITCH expression...

However, if the list is static, I would probably create it in Excel including the index column and copy/paste it into a table using "Enter Data" in the ribbon.

Forum Discussion

Create Index on a table in Data pane and not in Power Query

Related content

Create new table

Can we create indexs for temp table in Fabric?

Lakehouse Table Generate Create Table

Create Index on Visual Table

Create rows from 2 tables