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...

Need Help

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

Forum Discussion

Combining timesheet files

Related content

Power Query Combine Multiple Files From Folder

Tables combine

Folder Combine Wizard creates sample file queries but does not generate final combined query

Combining Files Error in Power Query

Append/ Combine Multiple Json Files