Date table connection to another table

[Anonymous]

I want to connect my date table with the TrackET but If I connect with the dates like delivery on in TrackET it shows nothing.

The dates in TrackET are from the Typ date and date/time is this the problem?
Here is my data. I want connect my date table with the dates for example PO Date from table trackit

[AllisonKennedy · Accepted solution]

You need to convert the Date Time to date so it will connect to your date table date. I would do this in Power Query if possible (there's even a button for it in the Add column tab), but you could use DAX functions as well.