Conditional Column

[amandabus21]

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. 

[andhiii079845]

You can try this:

left([your column],3) = "PED"

Only the first 3 words will be checked.

[amandabus21]

How would I add that in power query?

I have a few other conditions in there.

[andhiii079845]

In this case i would create a translations table with the current value and the new value to maintain it better. 

[amandabus21]

How would I do that?

[andhiii079845]

Do you mean PED has to be in the beginning of the word?

[amandabus21]

It could be beginning of a word example "Pedestrain" or its own word "PED" 

[KeyurPatel14]

Hi @amandabus21 ,
Can you please sample data and expected output as it will help me to solve this quicker?
Thank you.

[amandabus21]

If you see, the only "pedestrian" signifciant event correct would be bus 810 because it has the word PED isolated on its own. Unlike the other ones that its just at the beginning, middle, or end of another word.

@KeyurPatel14