Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Combining timesheet files

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.

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    7 years ago

    Use an Append query in Power Query.

     

    Or you could use UNION in DAX

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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.