Reputation: 59
I have 2 tables:
Date
----
01/01/2022
02/01/2022
03/01/2022
.
.
.
Resource Name
-------------
Resource A
Resource B
.
.
.
I want to combine both tables into one table with the following format:
Resource Name | Date
---------------------
Resource A | 01/01/2022
Resource A | 02/01/2022
Resource A | 03/01/2022
Resource A | .
Resource A | .
Resource A | .
Resource B | 01/01/2022
Resource B | 02/01/2022
Resource B | 03/01/2022
Resource B | .
Resource B | .
Resource B | .
.
.
.
How can this be done using either Power Query or DAX [PowerBi]?
Upvotes: 0
Views: 198
Reputation: 21318
In powerquery,add column, custom column
= NameOfOtherTableGoesHere
Then click the arrow atop the column and expand to rows
Upvotes: 2