Date Table Not Populating

[Monish2291]

Hi Team,

I have created a date table with the help of existing field available in another table and also given relation to it. When tried to pull both the fields into table visual it is not populating.screen shots are below.

[ToddChitt]

I know that the CALENDAR DAX function will result in a list of values of type DATE. I'm curious about the [Created] column. Is it, in fact a DATE type coming from Power Query, or is it a DATETIME type and you have simply masked it to format/display as a date? Also, I bet the answer lies somewhat related to the fact that it is matching a value of 2/5/2024 from the CALENDAR table to 2/4/2024 in the other. 

Are there any other co-workers you can have create this same model structure on there version of Power BI Desktop to see if maybe yours didn't get corrupted?

Can you share your Power Query M script, highlighting the handling of CREATED column? Maybe a screen shot from Power Query?

[ToddChitt]

Why is it that the [Date] column and the [CREATED] column are one day off? If they are part of the relatinship, they need to be EQUAL, right? Is there something about the table visual that would cause this to happen?

Are both columns DATE type?

What happens if you hard-code the start and end dates in the CALENDAR function?

[Monish2291]

Hi Todd,

Both the column are having date as their datatype. I don't why this is happening and why data is not populating, it is not about the table visual.

If I hard coded also i am facing same issue.