Forum Discussion
If - else function with two Text.Contains functions combined with "and"
I was able to create a new column for the specified condition with final else condition. Make sure to use the correct column names.
Let us know if this helps.
I was able to create a new column for the specified condition with final else condition. Make sure to use the correct column names.
Let us know if this helps.
VasTg: Thanks your reply. In your screenshot I noticed something, which I was doing wrong: I used a "=" instead of a "," in the second statement. But still I receive this error message:
An error occurred in the ‘xxx’ query. Expression.Error: The field 'Interface name' of the record wasn't found.
One more information which I missed to provide: My if-else contains several loops. Only two of them are extended with an "and" clause.
Do you think Power BI might have an issue in this regard?