Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Date Table relationship not working!

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!

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      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.