Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
SNik
Helper I
Helper I

LIKE Clause in M

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

Sincerely
Nik- Shahriar Nikkhah
1 ACCEPTED SOLUTION
pqian
Employee
Employee

@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...

View solution in original post

1 REPLY 1
pqian
Employee
Employee

@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...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.