Forum Discussion
admin11
Memorable Member
Memorable MemberHow 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_...
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.
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.
admin11Anonymous
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")