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.
Dear All,
need help to find specific word from the cell / row wise and display output in anthere collumn
e.d
Customer is very upset and angry, need Shipment delivery ASAP
Need to look for upser,Angry and ASAP and put the same in another collumn to plot word cloud graph
Appericiate your support and looking or solution on the same
Many Thanks
Sameer
Solved! Go to Solution.
Hi @mkazi ,
If you prefer to do this in the Power Query editor then I would do it like this to have a non case-sensitive result:
if Text.Contains([#"Details of the Complaints / Suggestions n Feedback"],"ASAP",Comparer.OrdinalIgnoreCase) then "ASAP"
else if Text.Contains([#"Details of the Complaints / Suggestions n Feedback"],"angry",Comparer.OrdinalIgnoreCase) then "Angry"
else if Text.Contains([#"Details of the Complaints / Suggestions n Feedback"],"Complaint",Comparer.OrdinalIgnoreCase) then "Complaint"
else "No"
Regards,
Hi @mkazi ,
I am glad it helped, if I answered your question please mark my post as the solution.
Regards,
Hi @mkazi ,
Try with this function: CONTAINSSTRING
https://dax.guide/containsstring/
Regards,
Hi Payres, trying to use the below if text.contains to get the below words from the table and each cell
anything to modify below
if Text.Contains([#"Details of the Complaints / Suggestions n Feedback"],"ASAP") then "ASAP" ,
if Text.Contains([#"Details of the Complaints / Suggestions n Feedback"],"angry") then "Angry"
if Text.Contains([#"Details of the Complaints / Suggestions n Feedback"],"Complaint") then "Complaint"
else "No")
Hi @mkazi ,
If you prefer to do this in the Power Query editor then I would do it like this to have a non case-sensitive result:
if Text.Contains([#"Details of the Complaints / Suggestions n Feedback"],"ASAP",Comparer.OrdinalIgnoreCase) then "ASAP"
else if Text.Contains([#"Details of the Complaints / Suggestions n Feedback"],"angry",Comparer.OrdinalIgnoreCase) then "Angry"
else if Text.Contains([#"Details of the Complaints / Suggestions n Feedback"],"Complaint",Comparer.OrdinalIgnoreCase) then "Complaint"
else "No"
Regards,
Thanks , i will use it as i jsut have to filter only Customer sentiment words , like ANGRY ETC...
it wil be max of 12 to 13 words
Hi @mkazi ,
I am glad it helped, if I answered your question please mark my post as the solution.
Regards,
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |