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_SI_GL%20rename%20TI%20with%20TT%20for%20SOURCe%20field.pbix?dl=0

 

Paul

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.

13 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.

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

      Anonymous 

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

      Paul Yeo

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

     

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

      Anonymous 

      That field is not availabel at PQ.

      Paul

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        I can see it ina acreenshot sent by you.

        Look at the yellow highlighter.

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

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

      Anonymous 

       

      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")