How to determine if a cell contains one of a set of characters

michaelmcalpine — Thu, 02 Mar 2023 14:22:11 GMT

Hello,

I am new to Power BI and am a bit overwhelmed by options to solve the following problem.

I have a table Queries that has a column with long text strings. I also have a table Accents that has a list of letters with French accents: 'é','ù','ç' etc.

I would like to know how many rows in Queries have characters with accents. I don't need to know how many accents or which accent, I just need a count of rows that contain one or more of the characters above.

I've tried googling and searching this, but I'm overwhelmed by choices: Contains, CountIF and comparing lists all seem like possible solutions, but I can't quite get any of them to work.

Any assistance is appreciated.

michaelmcalpine Tracker

How to determine if a cell contains one of a set of characters