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

gnatnug — Wed, 13 Jul 2022 16:26:33 GMT

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

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

PaulOlding — Wed, 13 Jul 2022 16:42:11 GMT

Hi gnatnug

Sounds like a job for the crossjoin function

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

gnatnug — Wed, 13 Jul 2022 16:59:28 GMT

Worked Perfect. Thanks.

topic Full outer join 2 tables similar to a 1=1 repeating values from B onto A in DAX Commands and Tips

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

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

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