Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm going crazy trying to get a simple formula working. I want to say, if location_ID is like 'AA%' THEN Y ELSE N. I've tried:
Solved! Go to Solution.
CONTAINS searches through a column of values for a particular value. You want to search text for a substring, so CONTAINSSTRING is probably closer to the function you want but LEFT might be a good choice for this situation too.
CONTAINS searches through a column of values for a particular value. You want to search text for a substring, so CONTAINSSTRING is probably closer to the function you want but LEFT might be a good choice for this situation too.
Yes, thank you, CONTAINSSTRING works!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |