Create a new table from two other tables

[baribir]

Hi All,

I need to make a new table from the contents of two other tables with DAX. And add a column with the time difference(Date1-Date2).

Table 1:

ID1	Date1
1	05-12-18
2	04-12-18
3	04-12-18
4	04-12-18

Table2:

ID2	Date2
1	20-11-18
2	27-11-18
3	04-12-18
4	11-12-18

A new table:

ID1	Date1	ID2	Date2	Diff
1	05-12-18	1	20-11-18	15
1	05-12-18	2	27-11-18	8
1	05-12-18	3	04-12-18	1
1	05-12-18	4	11-12-18	-6
2	04-12-18	1	20-11-18	14
2	04-12-18	2	27-11-18	7
2	04-12-18	3	04-12-18	0
2	04-12-18	4	11-12-18	-7
3	04-12-18	1	20-11-18	14
3	04-12-18	2	27-11-18	7
3	04-12-18	3	04-12-18	0
3	04-12-18	4	11-12-18	-7
4	04-12-18	1	20-11-18	14
4	04-12-18	2	27-11-18	7
4	04-12-18	3	04-12-18	0
4	05-12-18	4	11-12-18	-6

[GilbertQ · Accepted solution]

Hi there

Here is the DAX code

Table = CROSSJOIN('Table1','Table2')

This will give you the result you want

[GilbertQ · Accepted solution]

Here we go

Table =
CALCULATETABLE (
    ADDCOLUMNS (
        CROSSJOIN ( 'Table1', 'Table2' ),
        "DateDiff", DATEDIFF ( 'Table1'[Date1], 'Table2'[Date2], DAY )
    )
)