topic Re: Conditional Column in DAX Commands and Tips

Conditional Column

amandabus21 — Mon, 20 Mar 2023 18:43:51 GMT

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.

Re: Conditional Column

andhiii079845 — Mon, 20 Mar 2023 18:54:30 GMT

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

Re: Conditional Column

amandabus21 — Mon, 20 Mar 2023 19:04:33 GMT

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

Re: Conditional Column

andhiii079845 — Mon, 20 Mar 2023 19:06:45 GMT

You can try this:

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

Only the first 3 words will be checked.

Re: Conditional Column

amandabus21 — Mon, 20 Mar 2023 19:13:57 GMT

How would I add that in power query?

I have a few other conditions in there.

Re: Conditional Column

KeyurPatel14 — Tue, 21 Mar 2023 04:44:44 GMT

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

Re: Conditional Column

andhiii079845 — Tue, 21 Mar 2023 08:45:01 GMT

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

Re: Conditional Column

amandabus21 — Tue, 21 Mar 2023 21:54:14 GMT

How would I do that?

Re: Conditional Column

amandabus21 — Wed, 22 Mar 2023 18:18:47 GMT

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