topic Re: Join two tables with non-equi join in DAX Commands and Tips

Join two tables with non-equi join

Anonymous — Mon, 24 Aug 2020 10:13:59 GMT

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!

Re: Join two tables with non-equi join

amitchandak — Mon, 24 Aug 2020 10:29:10 GMT

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

Re: Join two tables with non-equi join

Anonymous — Mon, 24 Aug 2020 12:25:32 GMT

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.