Forum Discussion

po's avatar
po
Post Prodigy
6 years ago

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