Facing issue with date dim in report

[AnandNamburi]

Hi All,

I'm using date dim which is imported from SQL DB and joined to Table A(Join condition is  Date column from Date Dim to Created Date in table A, both data types are same).

When I pull date doulmns from both into a report the date dolumn from date dim is getting blank as shwn in below screenshot.

Can anyone let me know how can I fix this issue.

Thanks,

Anand

[HotChilli]

More info please. Did you change the type in Power Query? Did you extract the date portion and use that as a column?

If you did it in Power Query, try a test by Merging the two tables with an Inner Join to see if they find matches

[HotChilli]

Respect to you because that is the correct way to test these things.

What is the datatype of the two fields? If it is datetime the time portion can cause the relationship to break.

Can you show some examples from Power Query screen please?

[AnandNamburi]

Initially the date type of these two fields are like datetime but later I have changed it to date in both tables.