Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
You can try this:
left([your column],3) = "PED"
Only the first 3 words will be checked.
Proud to be a Super User!
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.
Proud to be a Super User!
How would I do that?
Do you mean PED has to be in the beginning of the word?
Proud to be a Super User!
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
42 | |
39 | |
33 | |
19 | |
18 |