Forum Discussion
Solved
Conditional Column not returning expected results
I have a column with data where I need to filter out lines with specific phrases and have found that the Conditional Column is not returning the results I would expect. The column it's drawing fr...
Hi,
can you use power query and do this in a custom column prior to a calculated column?
if so try:
if Text.Contains([Text Field],".Phrase.") then "X" else "Y"
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
can you use power query and do this in a custom column prior to a calculated column?
if so try:
if Text.Contains([Text Field],".Phrase.") then "X" else "Y"
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Gives a Y answer for the lines that should be flagged X, unfortunately.