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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
gnatnug
Microsoft Employee
Microsoft Employee

Full outer join 2 tables similar to a 1=1 repeating values from B onto A

I have 2 tables, A and B.  I want to full outer join data from B onto A.  In Sql, I know how I would do i.e. FULL OUTER JOIN B on 1=1. I'm looking for the same in DAX.  Examples of A, B and Outcome below. 

 

A
ItemDesc
3870pink hat
45783blue scarf
5427red dress
648yellow gloves

 

B
ProductCtgry
wearableCotton
wearablePoly
wearableRubber
wearableHemp

 

Outcome
ItemDescProductCtgry
3870pink hatwearableCotton
3870pink hatwearablePoly
3870pink hatwearableRubber
3870pink hatwearableHemp
45783blue scarfwearableCotton
45783blue scarfwearablePoly
45783blue scarfwearableRubber
45783blue scarfwearableHemp
5427red dresswearableCotton
5427red dresswearablePoly
5427red dresswearableRubber
5427red dresswearableHemp
648yellow gloveswearableCotton
648yellow gloveswearablePoly
648yellow gloveswearableRubber
648yellow gloveswearableHemp
1 ACCEPTED SOLUTION
PaulOlding
Solution Sage
Solution Sage

Hi @gnatnug 

Sounds like a job for the crossjoin function

View solution in original post

2 REPLIES 2
PaulOlding
Solution Sage
Solution Sage

Hi @gnatnug 

Sounds like a job for the crossjoin function

Worked Perfect.  Thanks. 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors