Forum Discussion
Solved
Simple Power Query Q: How to make a composite key
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 YYYY...
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.
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.
Thanks MarcelBeug, small problem, BIG help!
