Date Table relationship not working!

[Anonymous]

Hey guys!

So, I have this relationship between my Invoice table and my Date Table:

But this is not working. When I try to see the invoice amount in a simple matrix with my date table this is what happens:

I double checked my date table time range and it covers all my data. Also, I verified the data types, and they are both the same (date only). I have searched for several hours and not found any solution yet.

These are the two fields I'm trying to relate:

Thank you in advance!

[Anonymous]

Already fixed the problem!! thank you very much!!!

[rtmarquee]

Do you mind sharing  your solution? I am having the same issue and I have check my data type for all match and when I look in power query all matches there too. 

[Ashish_Mathur · Accepted solution]

Hi,

Share the download link of the PBI file.