Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Matthijs_NL
Regular Visitor

CrossJoin with filters returns all but first date

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. 

 

Matthijs_NL_0-1690920715978.png

 

Any thoughts on the cause?

 

1 ACCEPTED SOLUTION
Matthijs_NL
Regular Visitor

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. 

View solution in original post

1 REPLY 1
Matthijs_NL
Regular Visitor

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. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.