Add empty column to table in power query

Hi,

Go to Add Column > Custom Column

Anonymous 

Add a custom column.

= null

Click the 'Custom Column' from the Add column tab and in the box either type

null

or

""

depending on the result you want. 

Here is sample code for advanced editor and/or formula bar if you want: 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSK1YlWMkImjZViYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Existing Column" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Existing Column", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Null Column", each null),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Blank Column", each "")
in
    #"Added Custom1"

Hi Anonymous,

on Power Query,

Add Custom Column,

Change Custom name to your desired column name,

Add in body ""

then Ok

Hope this helps.