Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
ValeriaBreve
Post Patron
Post Patron

join based on conditions

Hello,

I would like to join 2 tables based on certain conditions.

Ex. is below - I would like to jojn the first to second table based on:

Col1/Col4 ONLY if Col5 is empty

Col1 and Col2/Col4 and Col5 if Col6 is empty

all Col1, 2 and 3 /Col 4,5 and 6 if  the latter are populated.

 

How would you do it? I have not found a good way to do such a "conditional" join....

Thanks!

Kind regards

Valeria

 

 

Col1Col2Col3  Col4Col5Col6Result
AFG  A  result1
BTY  B  result2
CGD  CGDresult3
DH   DH result4
         
         
         
Final Table       
         
Col1Col2Col3Result     
AFGresult1     
BTYresult2     
CGDresult3     
DH result4     
         
1 ACCEPTED SOLUTION
RocketRod
Frequent Visitor
2 REPLIES 2
RocketRod
Frequent Visitor

thanks!

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.