Forum Discussion

160475's avatar
160475
Helper I
4 years ago
Solved

cocatenated value

Dears,

i have 2 columns one is branch gender where the values are 1 or 2 

the second column is branch number where the values from branch 1-10

i would like to creat a new column where the values will be branch number - branch gender ex: 9-1,9-2,10-1,10-2 etc 

can anyone help ?

 

thanks 

Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi 160475 ,

     

    In Power Query, try a new custom column with this calculation:

     

    Text.Combine({Text.From([branch]), Text.From([gender])}, "-")

     

     

    If this causes you an issue with query folding, then use this instead:

     

    Text.From([branch]) & "-" & Text.From([gender])

     

     

    Pete

1 Reply

  • BA_Pete's avatar
    BA_Pete
    Super User
    4 years ago

    Hi 160475 ,

     

    In Power Query, try a new custom column with this calculation:

     

    Text.Combine({Text.From([branch]), Text.From([gender])}, "-")

     

     

    If this causes you an issue with query folding, then use this instead:

     

    Text.From([branch]) & "-" & Text.From([gender])

     

     

    Pete