How to replace value label TI with TT for SOURCE field ?

[admin11]

Hi All

I have a field = SOURCE , The value label have TI , TS 

I like to replace TI with TT and TS with SS

My PBI file :-

https://www.dropbox.com/s/z3w777jy4d8nynd/PBT_V2021_392%20TI_SI_GL%20rename%20TI%20with%20TT%20for%2...

Paul

[v-yangliu-msft · Accepted solution]

Hi  @admin11  ,

Here are the steps you can follow：

1. Create calculated column.

Column =
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE('Table'[Column1],"TA","A"),
"TP","B"),
"TI","C"),
"TS","D")

2. Result：

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[admin11]

@v-yangliu-msft 

Thank you very much for your help , it work fine now. apprecaite very much.

Paul Yeo

[v-yangliu-msft]

Hi  @admin11  ,

Here are the steps you can follow：

1. Create calculated column.

Column 2 =
SUBSTITUTE(
    SUBSTITUTE(
    'Table'[Column],"TI","TT"),
    "TS","SS")

2. Result：

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[admin11]

@v-yangliu-msft 

Thank you very much for your support , your code work fine , but when i need add 2 more , again i get error , hope you can advise me how to work around .

SOURCE NEW =

SUBSTITUTE(

SUBSTITUTE(

'Source'[SOURCE],

"TA","A"),

"TP,"B"),

"TI","C"),

"TS","D")

[v-yangliu-msft]

Hi  @admin11  ,

Here are the steps you can follow：

1. Create calculated column.

Column = SUBSTITUTE('Table'[SOURCE],"TI","TT")

2. Result：

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[admin11]

@v-yangliu-msft 

Thank you very uch for your help , your code is working fine.

I also want to repalce TS with SS.

I try below code :-

SOURCE_NEW = SUBSTITUTE('Source'[SOURCE],"TI","TT","TS","SS")

I get error msg :-

[Anonymous]

Go to power query editor and use Replace Values button from transform

[admin11]

@Anonymous 

That field is not availabel at PQ.

Paul

[Anonymous]

I can see it ina acreenshot sent by you.

Look at the yellow highlighter.

[amitchandak]

@admin11 , Do it power query, Right click replace

https://www.youtube.com/watch?v=hkZhZbR7Kmk

[admin11]

@amitchandak

May i know how to do it at DAX , as SOURCE is not available at PQ. 

[amitchandak]

@admin11 , in DAX you can use substitute

https://www.youtube.com/watch?v=y5HvChhMWbQ

substitute ([Column], "TI", "TT")

[admin11]

@amitchandak 

Thank you very much for your help , i get error :-

By the way i have TS want to change to SS 

and TI change TT.