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
There have been solutions offered regarding searching string text using a list of values, eg:
2. https://community.powerbi.com/t5/Desktop/joinAlgorithm-and-keyEqualityComparers/m-p/182148#M79842
...but these do not address the following challenge
PROBLEM
Text: "I LOVE MOTORBIKES".
List of Values: BIKES, BIKE, MOTOR, MOTORBIKE, MOTORBIKES
CHALLENGE: When I perform the comparison, ONLY "MOTORBIKES" should return TRUE.
Is there a way of doing this in Power Query
Thanks in advance
Alfred
Solved! Go to Solution.
Can you please show me how to do this? I am stuck. Thank you.
you convert the text to list and then use list comparators, e.g. List.Contains
https://docs.microsoft.com/en-us/powerquery-m/list-contains
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.