Forum Discussion
Solved
Combine 2 Tables in Power Query
Hi All,
I was wondering if it possible to combine 2 tables in PowerQuery - similar to the SUMMARIZE function in dax. I do not want to use DAX as I need to use some functions in Power Query.
I have the scenario below where I have 2 tables - a name table and a date table. Essentially I want an entry of each item in the name table per date.
Thanks in advance,
Alex.
amoller96 That's not really what SUMMARIZE does typically. It sounds like you want a crossjoin: Creating a Crossjoin (All Combinations) in Power Query (gorilla.bi)
2 Replies
amoller96 That's not really what SUMMARIZE does typically. It sounds like you want a crossjoin: Creating a Crossjoin (All Combinations) in Power Query (gorilla.bi)
Exactly what I needed, thanks a lot! 🙂
