locked
Filling column with Row Numbers RRS feed

  • Question

  • How to fill a column with row number in power query like below? is there any function in power query?

    Color       Row Number

    Red         1

    Green      2

    Blue         3

    Wednesday, November 5, 2014 9:20 AM

Answers

  • Hi...

    You can use "Add Index Column" function in Add column tab as below :

    Table.AddIndexColumn(Source, "Row Number", 1, 1)

    Regards,

    • Marked as answer by ssijbabu Wednesday, November 5, 2014 2:08 PM
    Wednesday, November 5, 2014 12:47 PM

All replies

  • Hi...

    You can use "Add Index Column" function in Add column tab as below :

    Table.AddIndexColumn(Source, "Row Number", 1, 1)

    Regards,

    • Marked as answer by ssijbabu Wednesday, November 5, 2014 2:08 PM
    Wednesday, November 5, 2014 12:47 PM
  • Hi CDZung,

    Thank you for the help.

    Regards

    Sujay

    Wednesday, November 5, 2014 2:08 PM