topic How remove the unwanted letters in a column. in DAX Commands and Tips

How remove the unwanted letters in a column.

Anonymous — Thu, 07 Apr 2022 15:13:47 GMT

Hello,

How can I remove the unwanted letters in the category column below?
I want to remove the PV from each row.
Thanks!

Whitewater100 — Thu, 07 Apr 2022 16:05:56 GMT

Hi:

You can do this a couple of ways I know. Here is a calc column:

New Cat = REPLACE(Data1[Category],21,2,"")

You can also do in Power Query with ADDCOLUNM > Column by examples and type in first two and computer will catch on and fix all of them.

Hope this helps!

Whitewater100 — Thu, 07 Apr 2022 16:08:26 GMT

Here is Power Query fix:

Anonymous — Wed, 13 Apr 2022 14:21:37 GMT

HEY Whitewater100 Thanks! It was really helpful.

Whitewater100 — Wed, 13 Apr 2022 14:33:21 GMT

Great! Thank you..