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

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