Forum Discussion
Solved
Create New Column with If Text Contains parameters
I'm sorry, I have read all the 'text contains' articles and have tried the formulas for my data, but I just can't get my formula to work! I have a table with a field with six possible values: Ne...
Hi, I am not sure if I understood your question correctly, but please try something like below.
One thing to note is that Uppercase and lowercase has to be exactly the same, when using Power Query Editor.
Thank you, yes your example is the result I am trying to achieve. Your insutrction helped the formula to run. However, I still get an error: A cyclic reference was encountered during evaluation.