Dates intermittently fail to relate. Please explain?

[PhilSmith]

Cut this down to the bare minimum. Two tables, Accounting, (sourced from a MYSql DB,) and Date, sourced from a spreadsheet.

These relate on accounting.post_date and Date.date. Some records will honor that relationship, some will not, but the data in the fields are the same in either case.  Someone please make this make sense.

BrandPNLDEVforForum.pbix

Thanx you

[lbendlin · Accepted solution]

You may think these are dates, but you will find they are actually DateTime columns, and not all of the values are pegged at 12:00:00 am.  Force convert everything to "date"  (which will do the midnight pegging).

[PhilSmith]

That was it.  First time working with this table, formatting hid the time from me.

Thank you very much.