Combining timesheet files

[Anonymous]

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.

[v-shex-msft · Accepted 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

[Anonymous]

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.

[Greg_Deckler]

Use an Append query in Power Query.

Or you could use UNION in DAX