Create table from 2 column and 2 table

[Anonymous]

Dear friends

how can i create table that combine "Date" from table 1 and "Value" from table 2 and let "Date" duplicate its selfves each row by each "Value"

Table1

Date

01-01-21

02-01-21

03-01-21

04-01-21

Table2

A

B

C

D

What i expected

Date	Value
01-01-21	A
01-01-21	B
01-01-21	C
01-01-21	D
02-01-21	A
02-01-21	B
02-01-21	C
02-01-21	D
03-01-21	A
03-01-21	B
03-01-21	C
03-01-21	D
04-01-21	A
04-01-21	B
04-01-21	C
04-01-21	D

thank you in advance for any suggestions

[amitchandak · Accepted solution]

@Anonymous , why only 2 dates are repeating. Noy 4.

Option in Dax is crossjoin

new tbale  = Crossjoin(Table1, Table2)

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

or

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[Anonymous]

@amitchandak sorry for misleading, i just need to shown as example , but all i need to repeat all date

[amitchandak]

@Anonymous , Try crossjoin, I given example in last update

[Anonymous]

@amitchandak it cant , Table 1 are Dax table and table1 and table2 are not relationship

[amitchandak]

@Anonymous , crossjoin mean table with no relation

refer: https://docs.microsoft.com/en-us/dax/crossjoin-function-dax