Forum Discussion

jolyp's avatar
jolyp
New Member
4 years ago
Solved

Merging data from different tables with several commons fields

Hello   I'm new in "measure" and "DAX" and after digging into this forum I did not find a solution yet.   I have two tables for employees booking 1/ for project booking "employee name" "date of...
Need Help
  • jolyp's avatar
    jolyp
    4 years ago

    Thanks Ashish

     

    After adding a column "type" and making the title of columns identical for both tables , I just used the "add queries"  to add the indirect table to the project table and I works fine. I can have all booking hours or filter using the new "type" column

     

    It was simpler that I expected

     

    Thanks for support

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

Here's my suggestion.  Edit the ID heading on both tables to a standard one, say ID.  Create another column in both tables titled as Type with only 2 entries under that column - Project and Indirect.  Append the two tables.  Create a Calendar Table with a relationship (Many to One and Single) from the Date of booking column of the appended table to the Date column of the Calendar Table.  In the Calendar Table, create all grouping columns such as Year, Month name and Month number (sort the Month name by the Month number).  To your visual/slicer/filter, drag any date dimension from the Calendar Tables.  Write this measure

Hours = sum(Data[Number of hours])

Hope this helps.

jolyp's avatar
jolyp
New Member
4 years ago

Thanks Ashish

 

After adding a column "type" and making the title of columns identical for both tables , I just used the "add queries"  to add the indirect table to the project table and I works fine. I can have all booking hours or filter using the new "type" column

 

It was simpler that I expected

 

Thanks for support

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    You are welcome.