Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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 | |
Item | Desc |
3870 | pink hat |
45783 | blue scarf |
5427 | red dress |
648 | yellow gloves |
B | |
Product | Ctgry |
wearable | Cotton |
wearable | Poly |
wearable | Rubber |
wearable | Hemp |
Outcome | |||
Item | Desc | Product | Ctgry |
3870 | pink hat | wearable | Cotton |
3870 | pink hat | wearable | Poly |
3870 | pink hat | wearable | Rubber |
3870 | pink hat | wearable | Hemp |
45783 | blue scarf | wearable | Cotton |
45783 | blue scarf | wearable | Poly |
45783 | blue scarf | wearable | Rubber |
45783 | blue scarf | wearable | Hemp |
5427 | red dress | wearable | Cotton |
5427 | red dress | wearable | Poly |
5427 | red dress | wearable | Rubber |
5427 | red dress | wearable | Hemp |
648 | yellow gloves | wearable | Cotton |
648 | yellow gloves | wearable | Poly |
648 | yellow gloves | wearable | Rubber |
648 | yellow gloves | wearable | Hemp |
Solved! Go to Solution.
Worked Perfect. Thanks.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.