Forum Discussion
Merging steps in Power Query
Is it possible to merge group by step with a previous step which is original table?
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
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.
3 Replies
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
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.
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 |
