Forum Discussion
Power Query - Row Number by Group on Tables
Hello, I have imported multiple tabs from a file using 'import from folder'. Each tab was loaded in as a table, and then I expanded them to combine into one data set. How can I create row numbers s...
Before you expand those "Table"s you can add a custom column with Table.AddIndexColumn([Custom.Data], "Index", 1,1), remove the original column and then expand the new one.
Pat
Before you expand those "Table"s you can add a custom column with Table.AddIndexColumn([Custom.Data], "Index", 1,1), remove the original column and then expand the new one.
Pat