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.
| User | Count |
|---|---|
| 10 | |
| 7 | |
| 5 | |
| 4 | |
| 3 |
| User | Count |
|---|---|
| 12 | |
| 11 | |
| 9 | |
| 8 | |
| 8 |