Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
I think you can do it, while creating a formula.
Check example
https://medium.com/chandakamit/power-bi-comparing-data-across-date-ranges-36be49b68613
Thanks for suggestion.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |