Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
You may use DAX below to add a calculated table.
Table = CROSSJOIN ( Table2, SELECTCOLUMNS ( FILTER ( Table1, Table1[DOW] = 1 ), "Date", Table1[Date] ) )
You may use DAX below to add a calculated table.
Table = CROSSJOIN ( Table2, SELECTCOLUMNS ( FILTER ( Table1, Table1[DOW] = 1 ), "Date", Table1[Date] ) )
That works brilliantly - Thanks