You can achieve this type of conditional join in Power BI by creating a calculated column in your table with the following formula:
= AND([start_date] <= [Business_date], [end_date] > [Business_Date])
This formula will return a Boolean value of True or False for each row in your table based on whether the condition is met or not.
You can then use this calculated column as a filter in your visualizations or as a join key in relationships between tables.
I hope this helps! Let me know if you have any other questions.
If the answer Happy Give a Like & are you satisfied with the Answer Make the question as Resolved
Thanks/Regards
Kannan.N
