Forum Discussion
po
6 years agoPost Prodigy
theta join (between operator)
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
2 Replies
- amitchandakSuper User
I think you can do it, while creating a formula.
Check example
https://medium.com/chandakamit/power-bi-comparing-data-across-date-ranges-36be49b68613
- poPost Prodigy
Thanks for suggestion.