Forum Discussion

admin11's avatar
admin11
Memorable Member
4 years ago
Solved

How to make Brand recode only return 3M ?

Hi All

 

I have field name BRAND_5 , it have 4 value lable , for example :-

3.0

3M

400A

4MM

 

I have below expression :-

 

BRAND_F =
SUBSTITUTE(
SUBSTITUTE('SALES_T'[BRAND_5],
"3M","3M"),
"3.0","3M")
 
Now it return as below :-

3M

400A

4MM

 

 May i know how to make it return :-

3M

 

Paul Yeo

Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    admin11  If you want to add a new column, try this:

     

    BRAND_F = 
Var _A = 
SUBSTITUTE(
SUBSTITUTE('SALES_T'[BRAND_5],
"3M","3M"),
"3.0","3M")
return
if(_A="3M",_A,blank())

     

     

    output:

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

     

8 Replies