Check if the expressions in a column include any of the words in a list

[janusd27]

Hello,
I am looking to perform the action provided in the tutorial below, with the Powerbi software

https://www.lecfomasque.com/power-query-verifier-si-les-expressions-dune-colonnes-comprennent-un-des...

Can you help me with this request, please?

[Jimmy801]

Hello @janusd27 

but the link provided shows an exact how to do.

Just follow it 🙂

Jimmy

[janusd27]

The article describes how to do with Powerquerry, but I am looking to achieve it with Powerbi and not excel

[Jimmy801]

Hello @janusd27 

Powerquery is part of PowerBI so I don't get the point and is just the same

Jimmy

[janusd27]

I am also looking for the equivalent of the formula below with Powerbi

=SI(NB.SI(A1;"*NBR*");"NBR";"")

[v-juanli-msft · Accepted solution]

Hi @janusd27 

Does your function mean:

cell B=if cell A1 contains "NBR" value, then return "NBR', else null(blank).

If so, you could create a conditional column in Home-> Edit queries->Add column,

Or create a calculated column in Modeling->New column

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.