Forum Discussion

Monish2291's avatar
Monish2291
Frequent Visitor
2 years ago

Date Table Not Populating

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 populati...
Need Help
ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
2 years ago

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?