Common data fields in two different data sources - how to merge them for the dashboard?

[mulla]

I have a scenario where I am looking at Date and Payment for employees on source. On another sources, I am looking at Date and Employee Clock in time. How do I merge these two sources so I can show one filter option for Date, and both the respective sources are changed.

Also, in these sources are other data points I want to merge such as EVENT TYPE, DEPARTMENT, JOB TITLE, EMPLOYEE NAME. All these fields also tie in both the data sources.

[Phil_Seamark]

Hi @mulla

You could try a DAX UNION to create a new calculated table.  I've just picked three columns, but you get the idea....

New Table = UNION 
        (
            SELECTCOLUMNS('Hours and Pay',
                                "Date",'Hours and Pay'[Date],
                                "Department",'Hours and Pay'[Date],
                                "Pay Code",'Hours and Pay'[Pay Code]),
                                
            SELECTCOLUMNS('Time Sheet Detail',
                                "Date",'Time Sheet Detail'[Date],
                                "Department",'Time Sheet Detail'[Date],
                                "Pay Code",'Time Sheet Detail'[Pay Code]
        ))