Complex Join with relation operators

[itcloud_Learn]

Hi ,

I have to do conditional join in power bi like "start_date<=Business_date AND end_date> Business_Date" how to achieve this type of conditional Join in power bi, i am using relational operators here <=& >. Could you please on this issue.

[Kannan_n]

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