theta join (between operator)

[po]

Hi,

Is the following possible in power bi in trems of setting up the relationships?

tablea.date between table.start_date and tableb.end_date

Know can do in sql and other tools and generally would use standard inner joins in power bi but wondered as to possibility of such theta join being used in power bi?

Thanks

[amitchandak]

I think you can do it, while creating a formula.

Check example

https://medium.com/chandakamit/power-bi-comparing-data-across-date-ranges-36be49b68613

[po]

Thanks for suggestion.