Forum Discussion
Conditional Column
Hello,
Im adding a conditional coliumn where I want it to do :
If Case containts "PED" then Pedestrians.
Is there a way I can make it that the word "PED" is its own word. I keep getitng a result where PED is in a word and not its own word.
Example I dont "WIPED" as a result.
8 Replies
Do you mean PED has to be in the beginning of the word?
It could be beginning of a word example "Pedestrain" or its own word "PED"
Hi amandabus21 ,
Can you please sample data and expected output as it will help me to solve this quicker?
Thank you.
You can try this:
left([your column],3) = "PED"
Only the first 3 words will be checked.
How would I add that in power query?
I have a few other conditions in there.
In this case i would create a translations table with the current value and the new value to maintain it better.
