none
Power Query - Adding new Rows

    Question

  • Hi,

    I have created a Power Query that builds a dimension table with a Key index column. The Key value for normal rows start at 1.

    Is it possible to add a new row with Power Query that will represent "NO VALUE" with a Key value of -1?

    Thanks in advance,

    Pål


    Monday, October 21, 2013 12:20 PM

Answers

  • Hi Pal,

    I think the easiest way to do this would be to create a one-row table in your sheet (one row plus headers) that has the same structure as the original table. You can create a query on top of this sheet table by using "From Table" in the Power Query ribbon tab. Then use "Append" (also in the Power Query ribbon tab) to append the original and the newly created query.

    Thanks,
    M.

    Tuesday, October 22, 2013 1:10 AM
    Owner