Combine tables and create a new line item for each combination

[kukszi]

Hi there,

I have two tables and I'd like to combine those into a third table and create a new line item for each combination:

Customer table:
Customer A
Customer B
Customer C

Product table:
Product 1
Product 2
Product 3

Expected outcome:
Customer A | Product 1
Customer A | Product 2
Customer A | Product 3
Customer B | Product 1
Customer B | Product 2
Customer B | Product 3
Customer C | Product 1
Customer C | Product 2
Customer C | Product 3

How can I get the expected outcome in DAX?

Thanks,
kukszi

[MahyarTF]

Hi,

Please have a look at the below article :

https://docs.microsoft.com/en-us/power-query/cross-join

Appreciate to Kudos

[ryan_mayu · Accepted solution]

@kukszi 

pls try this

Table = CROSSJOIN(Customer,'Product')

[kukszi]

Perfect, thank you very much @ryan_mayu

[ryan_mayu]

you are welcome