Forum Discussion

mulla's avatar
mulla
New Member
9 years ago

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

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.

 

Need Help

1 Reply

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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]
        ))