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.
Any thoughts on how to accomplish this? I need to create a custom column to filter down existing values that are aliases into my company name, but then need keep the rest of the company name values in the table the same as they are today. I can't not have a closing else statement, so is there something I can use as the ending clause to essentially say, do nothing with everything else..
if Text.Contains([#"Manufacturer"], "myCompany") then "myCompany"
else if Text.Contains([#"Manufacturer"], "otherName") then "myCompany"
else if Text.Contains([#"Manufacturer"], "secondName") then "myCompany"
else //I don't want to do anything here and need to keep the rest of the values that exist in the table as they are
Solved! Go to Solution.
Hi @sffc ,
Couldn't you just specify the column that you would like to keep in the else statement? Like "else [company]"?
/Tom
https://www.instagram.com/tackytechtom
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Yes, good idea. That works good. Thanks, Tom!
Hi @sffc ,
Couldn't you just specify the column that you would like to keep in the else statement? Like "else [company]"?
/Tom
https://www.instagram.com/tackytechtom
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
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 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |