Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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