Date Table Relationships Reads all Dates as 'Blanks'?

[Flawn]

Hello All,

I have a really peculiar issue with my data table that I need help solving:

The first set of date info is from the find table's internal dates (which the date table is related to that table by) the second set of dates - which are (mostly) blank, are from the date table itself. After some looking around it appears that when I try to use filters via the date table, the overwhelming majority - but not all-  of find table's dates read as 'blank', second image should help clarify:

I have no idea what the heck is going on here - I appreciate any help that people can provide.

PBIX here: https://drive.google.com/file/d/1GxtoCfmo90ZfkphF5mWzG8wN3UCHN6UJ/view?usp=sharing 

Warm Regards,
Flawn

[Idrissshatila · Accepted solution]

Hello @Flawn ,

I've faced this before, the issue is that the column in the fact table is date time, so the solution is to go to Power query and change the datetime column type to date.

this only works when changed in Power query.

[Flawn]

I can't help but be a little annoyed that the solution was so simple! Thanks.

[Idrissshatila]

Hello @Flawn ,

I've faced this before, the issue is that the column in the fact table is date time, so the solution is to go to Power query and change the datetime column type to date.

this only works when changed in Power query.