COMBINE TABLES REPEAT LINES

[soji]

Hi  Can someone help me to combine two tables in POWER BI as mentioned below. I have Date table and Store table and i want a new table with data as shown in Result table.

Date Table		Store Table
Date		Store ID
01.Sep.20		S001
02.Sep.20		S002
03.Sep.20		S003
Result Table
01.Sep.20	S001
01.Sep.20	S002
01.Sep.20	S003
02.Sep.20	S001
02.Sep.20	S002
02.Sep.20	S003
03.Sep.20	S001
03.Sep.20	S002
03.Sep.20	S003

[amitchandak · Accepted solution]

@soji , You can use cross join

nueva tabla: crossjoin([Date Table],[Store Table])

If necessary, use selectcoumns to take the column you wanted