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.
amitchandak
Super User
Super Useradmin11 , Do it power query, Right click replace
admin11Memorable Member
Memorable Member- amitchandak
admin11 , in DAX you can use substitute
https://www.youtube.com/watch?v=y5HvChhMWbQ
substitute ([Column], "TI", "TT")
- admin11
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.