Forum Discussion
po
Post Prodigy
6 years agotheta 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
- amitchandak
Super 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
- po
Post Prodigy
Thanks for suggestion.