Text Contains Token Eof Expected Error

[t0talz]

Hi,

I can't make any clue of this error message... this function is so simple, I checked multiple times the syntax. Still don't understand how this formula is wrong (for creating custom columen in query editor):

 IF Text.Contains([Hostname], "myhost.com") THEN "1" ELSE "0"

The same result (error) with this code:

 IF (Text.Contains("abc", "a")) = true THEN 0 ELSE 1

[t0talz · Accepted solution]

PowerQuery is case sensitive.... now thats really frustrating, this is not stated in the function references...