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

[steambucky]

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?

[ValentinBIA · Accepted solution]

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

[steambucky]

Thanks Valentin, You rock! 🙂

[Thejeswar]

Hi,

The Below is the way you achieve it

Concatenated_Column = CONCATENATE([Year],CONCATENATE("-",[Month]))