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.
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?
Solved! Go to 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.
The article describes how to do with Powerquerry, but I am looking to achieve it with Powerbi and not excel
I am also looking for the equivalent of the formula below with Powerbi
=SI(NB.SI(A1;"*NBR*");"NBR";"")
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.
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.