Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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:
@SNik PowerQuery language do not have "like" operator support. The post is referring to a custom function the author posted in another blog entry:
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |