Table.TransformColumns(Source, {{"Item", each _ ?? "OtherColumn" , type text}}) coalesces not work

[Anonymous]

Just testing some syntax in vs code 

why does this work 

let

    Source =   Table.FromRecords({

        [OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0, Shipping = 10.00],

        [OrderID = 2, CustomerID = 1, Item = null, Price = 5.0, Shipping = 15.00],

        [OrderID = 3, CustomerID = 2, Item = "Fishing net", Price = 25.0, Shipping = 10.00]

    }),

  ReplacedNulls = Table.TransformColumns(Source, {{"Item",  each if _ = null then "OtherColumn" else _, type text}})

in

    ReplacedNulls

but this doesnt. Using the power query sdk in vscode to test this. I thought the coalesces should work.  Just curious if the below works for others.

let

    Source =   Table.FromRecords({

        [OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0, Shipping = 10.00],

        [OrderID = 2, CustomerID = 1, Item = null, Price = 5.0, Shipping = 15.00],

        [OrderID = 3, CustomerID = 2, Item = "Fishing net", Price = 25.0, Shipping = 10.00]

    }),

  ReplacedNulls = Table.TransformColumns(Source, {{"Item",  each _ ?? "OtherColumn" , type text}})

in

    ReplacedNulls

Cheers 

[Anonymous]

Hi @Anonymous ,

Please be aware, Power Query SDK provides functionality related to the development and testing of Custom Connectors for Power Query and Power BI.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ZhangKun]

Yes, the error message is:"token comma expected"(in vs). Maybe it's a bug? I think you can ask Microsoft or the plugin author.

[Omid_Motamedise]

Both are correct and work for me

[Anonymous]

maybe its the vscode powerquery sdk 

Could you try it in VScode ? 

[PwerQueryKees]

powerquery sdk in VSCode? Where do I get that??

[Anonymous]

Vs code extension you can download power query sdk extensions

[ronrsnfld]

Sorry. I do not have that tool.

[ronrsnfld]

Both work fine for me using Power BI Desktop