CrossJoin with filters returns all but first date

[Matthijs_NL]

Hi,

I'm using a crossjoin formula in combination with a filter to create a new table, see formula below. It's in dutch, it combines the employees (MdwDienstverband) with a datetable (Datumtabel) and filters the dates on the startdate of the employee (Datum_in_dienst)

MdwDatum = Filter(crossjoin(Afas_MdwDienstverband,values(Datumtabel[Date])),Datumtabel[Date] >= Afas_MdwDienstverband[Datum_in_dienst])

This works well, except that it skips the first date of "Datum_in_dienst". A screenshot as an example below. Our employee DTO started on the 1st of November 2022, but the first day is the 2nd of November 2022 (column "Date"). I'm using greater then or equal to ">=", so I would expect that the 1st date is also included, but for some reason it is not. 

Any thoughts on the cause?

[Matthijs_NL · Accepted solution]

Found it, it was a date/time and the startdate had a time of 01:00:00, so after 00:00:00 and therefore it didn't include the date.