Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |