how to build relationship between two date from two different tables and calculate the diff

[SelflearningBi]

I would like to place these two dates ( yellow) in the matrix table and also calcualte the date difference. and also put SKU, SALES MEETING, AND SUPPLIER NAME(pink) from the master table in the matric table in the visual as well. Once I put the date in, it shows no relationship between these two dates and it turns into can't display this visual  Please help. very apprecaited and thanks so much !!

[Anonymous]

Hi @SelflearningBi 

You have to delete the relationship on table with report date and calander and create relationship with the master table based on related ID fileds to use the datediff fucntion.

[SelflearningBi]

Hi thank you for helping, did you meant I have to delate the relationship for calander and connect signle ID from a dimension table? but still doesnt work, I still cant put these two dates into one table. please see my screeshot