Merging steps in Power Query

[yevhen_87]

Is it possible to merge group by step with a previous step which is original table?

[Anonymous · Accepted solution]

Yes it is possible. All you need to do is refer to the previous step as your table name, and a column that exists in the source table as your matching column. So

ThisStep = Table.NestedJoin(GroupingStep, {"ColumnName"}, Source, {"OtherColumnName"}, "JoinColumnName", JoinKind.LeftOuter)

You can use any step in your query that returns a table, as a parameter in a table function, and there are lots of good reasons to do it.

--Nate

[Omid_Motamedise · Accepted solution]

Yes, it is possible, conside the next example

use the merge with the setting provided in the nex image (use the same table in left and right part)

this is resulting the following formula

= Table.NestedJoin(#"Added Custom", {"Date"}, #"Added Custom", {"Date"}, "Added Custom", JoinKind.LeftOuter)

replace #"Added Custom" with name of previous step (Index) and  if theire column name is different,  replace date in  {"Date"} with the name of the column in the Index step you want to use for merging.

[Anonymous · Accepted solution]

Yes it is possible. All you need to do is refer to the previous step as your table name, and a column that exists in the source table as your matching column. So

ThisStep = Table.NestedJoin(GroupingStep, {"ColumnName"}, Source, {"OtherColumnName"}, "JoinColumnName", JoinKind.LeftOuter)

You can use any step in your query that returns a table, as a parameter in a table function, and there are lots of good reasons to do it.

--Nate

[uzuntasgokberk]

Hello @yevhen_87 ,

İt is not possible in the same 1 query. But Yes, it is possible but in your Power Query you need 2 different query. You can duplicate your original query or reference(on previous step group by). Your second query needs to be added group by step and then merge 2 table.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |