Forum Discussion
How to get values from previous step in a query without adding a new query ?
Hello, here I have a table with 4 columns. In the Screenshot below, I filtered the table by Purchase as "Tv" and Method as "Cash" In the screenshot below, I grouped the ID by Purchase a...
You can do:
Table.Join(Source, {"ID"}, #"Grouped Rows", {"ID"}, JoinKind.LeftOuter.
You can refer to any step name in your current query as a table.
--Nate