Forum Discussion
Merging two table
Hi All,
I have two Table. How can i merge the two tables to get final out put
Table 1
| Field1 |
| A |
| B |
| C |
Table 2
| Field2 |
| X |
| Y |
| Z |
Final Output Table
| Field1 | Field2 |
| A | X |
| A | Y |
| A | Z |
| B | X |
| B | Y |
| B | Z |
| C | X |
| C | Y |
| C | Z |
I think there's a CROSSJOIN function in DAX.
2 Replies
I think there's a CROSSJOIN function in DAX.
Anonymous ,
crossjoin(Table1, Table2) , all column should different name, otherwise use selectcolumns
