LIKE Clause in M

[SNik]

Hi i am working on a sample in

http://blog.crossjoin.co.uk/2014/06/02/join-conditions-in-power-query-part-1/

and it is using the LIKE clause at the end

= Table.AddColumn(ExpandedTable, "Custom", each Like([Patterns] , [Phrases]))

i am getting an error "Expression error: The name 'Like' wasn't recognized.  Make sure it's spelled correctly."

What is the LIKE clause in M language in PowerBI?

Sincerely

Nik

[pqian · Accepted solution]

@SNik PowerQuery language do not have "like" operator support. The post is referring to a custom function the author posted in another blog entry:

http://blog.crossjoin.co.uk/2014/05/27/implementing-a-basic-likewildcard-search-function-in-power-qu...