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.
I have two timesheet data sources, one for employees and one for contractors.
They both use a unique ID, a date and the number of days worked
The contractors table has four columns, unique ID, date, hours, number of whole days worked
The employee table has a lot of additional information such as cost centres etc which I don't need but am not worried about keeping in it if I'm adding stuff.
How do I merge/append/join them? Not sure which I should be using.
Solved! Go to Solution.
HI @Anonymous,
I'd like to suggest you merge them with dax formula.
Sample: use selectcolumns and union functions to combine them.
Merged = UNION ( SELECTCOLUMNS ( contractors, "unique ID", [unique ID], "date", [date], "hours", [hours], "workdays", [workdays], "Source", "contractors" ), SELECTCOLUMNS ( employees, "unique ID", [unique ID], "date", [date], "hours", [hours], "workdays", [workdays], "Source", "employees" ) )
Regards,
Xiaoxin Sheng
HI @Anonymous,
I'd like to suggest you merge them with dax formula.
Sample: use selectcolumns and union functions to combine them.
Merged = UNION ( SELECTCOLUMNS ( contractors, "unique ID", [unique ID], "date", [date], "hours", [hours], "workdays", [workdays], "Source", "contractors" ), SELECTCOLUMNS ( employees, "unique ID", [unique ID], "date", [date], "hours", [hours], "workdays", [workdays], "Source", "employees" ) )
Regards,
Xiaoxin Sheng
Gah union! Yes that's the one. For anyone else doing this, don't forget to change the data type of any date field to date - had me scratching my head for a bit as to why the time slicer wasn't working.
Use an Append query in Power Query.
Or you could use UNION in DAX
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |