Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey All, I have "short description" column that list the descriptions of support tickets. I would like to create a new column based on a word or words that appear in the short description.
For example
Short_Description
Issues with Monitor
Issues with Display
New column would return the word "Monitor" for any row that contains the words "Monitor" or "Display".
Now I can get this working with one specific word as follows:
if Text.Contains([short_description], "Monitor") then "Monitor" else "0")
I just am struggling getting it to work with mutiple words/ text values.
Thank you!
Solved! Go to Solution.
@EricC,
Add a custom column using the following code.
if Text.Contains([short_description], "Monitor") then "Monitor" else if Text.Contains([short_description], "Display") then "Display" else "0"
Regards,
Lydia
@EricC,
Add a custom column using the following code.
if Text.Contains([short_description], "Monitor") then "Monitor" else if Text.Contains([short_description], "Display") then "Display" else "0"
Regards,
Lydia