Forum Discussion
Syndicate_Admin
4 years agoAdministrator
Create table by joining 2 others
Good morning.
Sorry I am new to the forum and accurate of your knowledge.
I have 2 tables created with DAX, one only contains the last 30 days, the other contains names of people. I need to create a new one that has 30 days X each person name. As I do not know if I have explained myself I give a summarized example
tabla1
10-01-2022
11-01-2022
12-01-2022
Table 2
Juan
Pedro
Desired table
10-01-2022 John
11-01-2022 John
12-01-2022 John
10-01-2022 Pedro
11-01-2022 Pedro
12-01-2022 Pedro
Thank you
Syndicate_Admin , Generate or crossjoin
Create a new table like
generate(table1, Table2)
or
Crossjoin(Table1, Table2)
1 Reply
- amitchandakSuper User
Syndicate_Admin , Generate or crossjoin
Create a new table like
generate(table1, Table2)
or
Crossjoin(Table1, Table2)