Forum Discussion
Power Query add new column
Greetings everybody, I'm trying to add an Id column with no luck via advanced query.
I could just create an excel file, but what's the fun on that?
Anyway, thank you for your help in advance, Kazuo.
Hi rikazuo
List.Numbers (1,100) should work fine and create a list of 100 numbers.
But what exactly is the issue?
If you want to add an Id column starting at 1 then you can do this from the GUI: Add Column -> Index Column -> From 1.
Or you can type this in manually into the Adv Editor
StepName = Table.AddIndexColumn(#"PreviousStepName", "Index", 1, 1, Int64.Type)Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
1 Reply
Hi rikazuo
List.Numbers (1,100) should work fine and create a list of 100 numbers.
But what exactly is the issue?
If you want to add an Id column starting at 1 then you can do this from the GUI: Add Column -> Index Column -> From 1.
Or you can type this in manually into the Adv Editor
StepName = Table.AddIndexColumn(#"PreviousStepName", "Index", 1, 1, Int64.Type)Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.