Forum Discussion

KevinGesquiere's avatar
KevinGesquiere
Frequent Visitor
8 years ago
Solved

Date Relationship Not Recognized?

Hi all,   Maybe a stupid question, but I can't figure out why it's not working correctly. I have 2 tables, a date table which I created using DAX (Date = CALENDAR (DATE(2000;1;1); DATE(2025;12;31)...
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Yeah, except I don't see a time component in your images and you aren't displaying it. By default, every time in a default CALENDAR table is 12:00:00 AM. I am thinking that perhaps your time component in your other table doesn't match. I would change the formatting to be sure.

  • KevinGesquiere's avatar
    KevinGesquiere
    8 years ago

    Hi Greg,

     

    Thanks! This was indeed the problem. I thought formatting both dates to Date (d/MM/yyyy) would work, but I had no clue that the time part of these dates still matter if it was formatted as date (d/MM/yyyy).

     

    Kr, Kevin

KevinGesquiere's avatar
KevinGesquiere
Frequent Visitor
8 years ago

Hi Greg,

 

Thanks for your respons. But the fact is that they are both Date/Time. Any other suggestions why this problem is coming up?

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Yeah, except I don't see a time component in your images and you aren't displaying it. By default, every time in a default CALENDAR table is 12:00:00 AM. I am thinking that perhaps your time component in your other table doesn't match. I would change the formatting to be sure.