Multiple if statement

[Anonymous]

Hi,

In our query tool beneeth multiple if statement is made. Can some one advice how to build this in Power BI?

I am especially interested in how to code the multiple if statement (I get the message that not more than 2 are acceptable) and how to code the validation on certain text in a certain column, so the 'not like' rows in the picture.

Thanks in advance!

[v-piga-msft · Accepted solution]

Hi @Anonymous,

For another option, you also could have a good look at this blog Multi Condition Logic In Power Query.

Best  Regards,
Cherry

[Anonymous]

@Anonymous,

You can create a Conditional column and select begins with in Operator section in Query Editor