Forum Discussion
Solved
Conditional column contains text
Hi, I'm trying to create a conditional column (Column Z) for when a certain column (Column A) contains a specific text. These texts are varying in lowercase, uppercase letters, and spacing. And...
annlois , You can compare both sides using Text.Upper - https://docs.microsoft.com/en-us/powerquery-m/text-upper
edit the code in advance editor or write if manually
annlois , You can compare both sides using Text.Upper - https://docs.microsoft.com/en-us/powerquery-m/text-upper
edit the code in advance editor or write if manually