Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
amandabus21
Helper V
Helper V

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 8
andhiii079845
Super User
Super User

You can try this:

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

Only the first 3 words will be checked.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




How would I add that in power query?

 

I have a few other conditions in there.

amandabus21_0-1679339624209.png

 

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




How would I do that?

andhiii079845
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

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.

amandabus21_0-1679508976163.png

 

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 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors