Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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.
Go to 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:
Text.From is not required if Employee ID is text already, but you forgot to mention.
View solution in original post
Thanks @MarcelBeug, small problem, BIG help!
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.