Simple Power Query Q: How to make a composite key

Question

How do you combine two columns to produce a composite key:

I have a Date column and an Employee ID column and i'd like to format the date into YYYYMMDD

and the final result would then be YYYYMMDDXXXXXX where XXXXXX is the Employee ID.

marcelbeug · Accepted Answer

Usually you can merge columns but I don't think that will give the right format.

So I would suggest to add a custom column with formula:

Date.ToText([Date],"yyyyMMdd")&Text.From([Employee ID])

Text.From is not required if Employee ID is text already, but you forgot to mention.

Forum Discussion