Forum Discussion

steambucky's avatar
steambucky
Icon for Helper III rankHelper III
8 years ago
Solved

Conactenating two fields BUT how do you put a delimiter between them?

 

 

Hello I am conactenating two fields, a (year and a month) and I get this:  : 20187

 

What I want is : 2018-7

 

Can you assist?

Need Help
  • ValentinBIA's avatar
    ValentinBIA
    8 years ago

    Hi steambucky,

     

    If you are trying to do so using DAX, you can just use the following measure:

    YearMonth = table[year] & "-" & table[month]

    Or you could use this one:

    YearMonth = CONCATENATE(Table[Year], CONCATENATE("-", Table[Month]))

     

    However, if you are trying to create a new column using Power Query, then you can select the 2 columns, right click, then "merge columns", and in this pop up you can select a separator, just input you character: -

     

    Hope that helps

     

    Best,

     

    Valentin

3 Replies

  • Thejeswar's avatar
    Thejeswar
    Icon for Super User rankSuper User
    8 years ago

    Hi,

    The Below is the way you achieve it

     

    Concatenated_Column = CONCATENATE([Year],CONCATENATE("-",[Month]))
  • ValentinBIA's avatar
    ValentinBIA
    Icon for Resolver I rankResolver I
    8 years ago

    Hi steambucky,

     

    If you are trying to do so using DAX, you can just use the following measure:

    YearMonth = table[year] & "-" & table[month]

    Or you could use this one:

    YearMonth = CONCATENATE(Table[Year], CONCATENATE("-", Table[Month]))

     

    However, if you are trying to create a new column using Power Query, then you can select the 2 columns, right click, then "merge columns", and in this pop up you can select a separator, just input you character: -

     

    Hope that helps

     

    Best,

     

    Valentin