Forum Discussion
Solved
Expression.Error in power query
Hi, I have created a custom column in order to filter out rows based on the criteria of 2 columns: Current Location + Next Location. If either of these columns contain the text "ICO", then the retu...
if Text.Contains( [Current Location] , "ICO") or Text.Contains( [Next Location] , "ICO") ?? false then "keep" else "omit"Text.Combine ( {[Current Location], " ", [Next Location]})Stéphane
if Text.Contains( [Current Location] , "ICO") or Text.Contains( [Next Location] , "ICO") ?? false then "keep" else "omit"
Text.Combine ( {[Current Location], " ", [Next Location]})
Stéphane
i was just missing the extra brackets then! thank you for your help!