Date Relationship not working

[khaycock]

My date relationship isn't working between my two tables and I can't figure out why!

They are both the same data type and format:

 

And the relationship is exactly what I would expect it to be..

Have I missed something??

[Icey]

Hi @khaycock ,

Please tell us why you think "Date Relationship not working"? Is there a specific performance?

Please provide some sample data and screenshots. Please remove sensitive information.

Best Regards,

Icey

[amitchandak]

@khaycock , There can be a couple of reasons. Form completion time has a datestamp and visible because of format. Change to datetime and format that has time and check. If has tome other than 12 AM. create a date field and join that

Form completion Date =[ Form completion time].date

Second that you might have used all or crossfilter in the formula. that can cause that

[Pragati11]

Hi @khaycock ,

If I see your screenshot, I see that Power BI has crrectly identified a MANY-to-ONE relationship between both tables.

Just wanted to understand why you think the relationship is not working?

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati