Power Query - Adding new Rows


  • 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,


    Monday, October 21, 2013 12:20 PM


  • 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.


    Tuesday, October 22, 2013 1:10 AM