creating relationship based on two or more columns

[syedsiraj10]

How we can create join based on range of date columns in powerbi

Eg: POSN_HIST JOIN TITLE ON POSN_HIST.TITLE_CD = TITLE.TITLE_CD AND TITLE.EFFECTIVE_DT <= POSN_HIST.EFFECTIVE_DT AND TITLE.EXPIRATION_DT >= POSN_HIST.EFFECTIVE_DT

Can someone please help me with the join condition logic we can use for creating the above join condition.

[blom0344 · Accepted solution]

Looks like you need a non-equi join that is not supported by PowerBI (yet). Try to write a view against these object and load the result to PowerBI

[blom0344]

In PowerBI there does not seem to be no support for non-equi joins, like the range join you are looking for. It is strictly  a  1:n  affair. But perhaps you solve this at the backend using a view and loading the view output as a dataset?