Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have two completely unrelated tables. One is from a query, and one is a Date table that I created by function. The first has a list of company names:
Company A
Company B
Company C
Company D
The second has a dynamic list of dates from the last year as follows:
1/1/2018
2/1/2018
3/1/2018
4/1/2018
I need an output table as follows:
Column A - Column B
1/1/2018 - Company A
2/1/2018 - Company A
3/1/2018 - Company A
...
1/1/2018 - Company B
2/1/2018 - Company B
3/1/2018 - Company B
...
And so on. Because the second table is a date table, I cannot use the Query Editor. This seems to be simple, but I can't quite get it. Any help is very much appreciated!
Solved! Go to Solution.
Hi @Anonymous
Try
NewTable = CROSSJOIN( TableA, TableB)
Nailed it!