Forum Discussion
Solved
Generate list from two queries without relationship
I have two tables in excel (Players and Games) with no common fields between them and want to generate a list with each player having all games listed. It is easy using a pivot in excel or quey in Access but I need this list generated with Power Query whenever players or games change and feed into a Power BI dashboard - Appreciate any help I can get - thanks in advance - Hennie
In your player table add the following...
#"Add gamesTable Column" = Table.AddColumn(#"Previous Step", "gamesTable", each gamesTable),
#"Expanded gamesTable" = Table.ExpandTableColumn(#"Add gamesTable Column", "gamesTable", {"Games", "Date"}, {"Games", "Date"})
2 Replies
In your player table add the following...
#"Add gamesTable Column" = Table.AddColumn(#"Previous Step", "gamesTable", each gamesTable),
#"Expanded gamesTable" = Table.ExpandTableColumn(#"Add gamesTable Column", "gamesTable", {"Games", "Date"}, {"Games", "Date"})