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.
Hi
I hope someone can help
I would like to use the add column feature of the query editor to search 2 columns of text and return a phrase if either contains what i am looking for.
I have written the formula but all it returns is errors, can anyone see the error in my formula?
if Text.Contains([Project Number], "ABCD") or Text.Contains ([Status 1],"ABCD") then "ABCD Related" else null)
Thanks for your help
Matt
Solved! Go to Solution.
what exactly error do you get? from my point everything look ok, except closed parenthesys ")" in the very end of your statement.
also be sure, your columns have a Text date type
what exactly error do you get? from my point everything look ok, except closed parenthesys ")" in the very end of your statement.
also be sure, your columns have a Text date type
Hi @az38
Thanks for getting back to me so quick. One of the columns wasnst specified to Text. ive changed it and it works great now.
Thanks
Matt
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 |
---|---|
113 | |
103 | |
76 | |
66 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
81 | |
68 |