Duplicating each row of a table

[Arkhos94]

I have a table looking like this (coming from excel) :

Country	Region
France	Europe
Germany	Europe
Japan	Asia
Canada	America

I want to dublicate each row of the table so I get something like this :

Country	Region	Brand
France	Europe	A
Germany	Europe	A
Japan	Asia	A
Canada	America	A
France	Europe	B
Germany	Europe	B
Japan	Asia	B
Canada	America	B
France	Europe	C
Germany	Europe	C
Japan	Asia	C
Canada	America	C

Is there a way to do that ?

[amitchandak · Accepted solution]

@Arkhos94 , Assume you have table that have brand (A,b,C)

you can create a new table

crossjoin(Table1, brand)

also check

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

[Arkhos94]

thank you both for the help

[Tahreem24 · Accepted solution]

@Arkhos94  - Create one table for Brand with the help of "Enter Data" option and create structure like this:

Then Create a new table with below DAX:

New Table = CROSSJOIN(CountryTable, Brand)

[amitchandak · Accepted solution]

@Arkhos94 , Assume you have table that have brand (A,b,C)

you can create a new table

crossjoin(Table1, brand)

also check

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/