Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! 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:
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |