Merging steps in Power Query

[yevhen_87]

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

[watkinnc · 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.

[watkinnc · 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.

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

İf this post helps, then please consider Accept it as solution and kudos to help the other members find it more quickly.