Power Query: Using Error Handling “try” and “otherwise”

[Guinaba]

Hi guys,

Any idea how I can wrap this function a “try” statement and if it gives an error then just throw the original value.

= Table.AddColumn(#"Expanded Logistics Brief", "fxRemoveDuplicateString", each fxRemoveDuplicateString([Logistics Brief.Promo Details]))

 

[smozgur]

Try this:

= Table.AddColumn(#"Expanded Logistics Brief", "fxRemoveDuplicateString", 
                        each try fxRemoveDuplicateString([Logistics Brief.Promo Details]) otherwise [Logistics Brief.Promo Details])