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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors