Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to create a new table in powerbi that joins two columns from different tables and creates combination of all records from each column. Thanks for the help!
Table 1:
Months
January 2017
February 2017
March 2017
Table 2:
Accounts
1
2
3
New Table
Month Account
January 2017 1
February 2017 1
March 2017 1
January 2017 2
February 2017 2
March 2017 2
January 2017 3
February 2017 3
March 2017 3
Solved! Go to Solution.
A solution in Power Query (Query editor - Advanced editor):
let Source = Table2, #"Added Custom" = Table.AddColumn(Source, "Custom", each Table1), #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Months"}, {"Months"}), #"Removed Other Columns" = Table.SelectColumns(#"Expanded Custom",{"Months", "Accounts"}) in #"Removed Other Columns"
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |