Blanks dates error with userelationship

[zmjerry]

Hello everyone,

I have a fact table with multiple columns of dates and I built my measures (distinctcount) using userrelationship by stating what date column to use in each measure.

I noticed my measure return lower number than it should be, so I pull both the date in datetable and the date in facttable as shown below.

You can see 6/10/2021, 6/13/2021 from the fact table did not found a match from the datetable.

What have I done wrong?

 

[zmjerry]

Solved it. The below help solved my problem

Re: Date table returns blank months

What seemed to do the trick was to in the query editor, go to the transform and extract the datetime value to just date. Thanks for the help.

community.powerbi.com