Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago
Solved

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

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_...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    admin11
    Icon for Memorable Member rankMemorable Member
    5 years ago

    Anonymous 

     

    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 :-