Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 7 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 17 | |
| 9 | |
| 8 | |
| 7 |