Power Query add new column

[rikazuo]

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.

[PhilipTreacy · Accepted solution]

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.