Simple Power Query Q: How to make a composite key

[ovetteabejuela]

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 solution]

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.

[ovetteabejuela]

Thanks @MarcelBeug, small problem, BIG help!