Join two tables with non-equi join

[Anonymous]

Hello,

I have troubles joining two tables in PowerBI and getting the result needed.

I have the Date table with a number of dates. This table gets filtered with a slicer, so I get a date range StartDate-EndDate. I also have the Event table, which needs to be joined to the Date table by non-equi join. The tables are to be joined by the next rule: EventStartDate<StartDate, EventEndDate>EndDate, where StartDate and EndDate are the first and last filtered dates on the slicer accordingly. Could anybody help and advise on how it should be done, please? Thanks in advance!

[Anonymous]

In PBI there is NO facility to create static non-equijoins. All static relationships (defined at load-time) must be equijoins out of necessity. Non-equijoins can be "created" on the fly by using DAX but these are virtual relationships, not material, that only last for the short time that DAX calculation takes place.

[amitchandak]

@Anonymous , refer this blog if this can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970