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...
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/

     

     

     

  • admin11's avatar
    admin11
    Memorable Member
    4 years ago

    VahidDM 

    I only want it return 3M only.

    i mean i don't want the rest of value label to be appear.

      • admin11's avatar
        admin11
        Memorable Member
        4 years ago

        VahidDM 

        I need it as column.

         

    • VahidDM's avatar
      VahidDM
      Super User
      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/

       

       

       

      • admin11's avatar
        admin11
        Memorable Member
        4 years ago

        VahidDM 

        Thank you very much it work fine now. 

        Very nice code easy to understand.