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 ...
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.
How would I do that?
