Generating A New Table

[Phil_P]

Hi,

I am very new to Power BI and need some assistance. I have two tables (with no related columns) and want to generate a third from the two. The idea is to generate a weekly statistics table (each Sunday) for my key transactions.

So my input tables are:

Table 1

Date Table
Date	DOW
01/01/2018 00:00	2
02/01/2018 00:00	3
03/01/2018 00:00	4
04/01/2018 00:00	5
05/01/2018 00:00	6
06/01/2018 00:00	7
07/01/2018 00:00	1
08/01/2018 00:00	2
09/01/2018 00:00	3
10/01/2018 00:00	4
11/01/2018 00:00	5
12/01/2018 00:00	6
13/01/2018 00:00	7
14/01/2018 00:00	1
15/01/2018 00:00	2

Table 2

Key Transaction
Application	Key Transaction	Time	Link
App1	Trans 1	3	ABC
App1	Trans 2	3	BCD
App1	Trans 3	2	CDE
App2	Trans 4	1	DEF

And what I am trying to create is:

Result
Date	Application	Key Transaction	Time	Link
07/01/2018 00:00	App1	Trans 1	3	ABC
07/01/2018 00:00	App1	Trans 2	3	BCD
07/01/2018 00:00	App1	Trans 3	2	CDE
07/01/2018 00:00	App2	Trans 4	1	DEF
14/01/2018 00:00	App1	Trans 1	3	ABC
14/01/2018 00:00	App1	Trans 2	3	BCD
14/01/2018 00:00	App1	Trans 3	2	CDE
14/01/2018 00:00	App2	Trans 4	1	DEF

Can anyone assist?

[v-chuncz-msft · Accepted solution]

@Phil_P,

You may use DAX below to add a calculated table.

Table =
CROSSJOIN (
    Table2,
    SELECTCOLUMNS ( FILTER ( Table1, Table1[DOW] = 1 ), "Date", Table1[Date] )
)

[Phil_P]

That works brilliantly - Thanks