Please find my mock up worksheet and where I used Date for creating relationship and joined data from 2 different sources. It seems to be working for me. I guess you have more complex source than me but it might give you some idea.
Please share your mock up workbook.
3 sources.twbx 44.3 KB