Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
PowerQuery is case sensitive.... now thats really frustrating, this is not stated in the function references...
PowerQuery is case sensitive.... now thats really frustrating, this is not stated in the function references...
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |