Can I add an XLOOKUP column after creating/loading the power query output?

[Mr_Phil]

Hi everyone. I am now working on my second PQ attempt. I'm hopeful because the append query in another project was fantastic. In this case I have a mass aggregator that in one instance needs to be unpivoted. So, I did that (Yay, so excited) by unpivoting other columns. then I realized that the source table did not have a column of data that I'd need in the query output. So, I am thinking that tomorrow I will try to add a column to the PQ output table that will look up the missing data via XLOOKUP. I can't test it tonight because I am away from the file location because I won't post it to the network until it is bulletproof. So curiosity compels me to ask if my idea will work... Learning a lot and seriously appreciating how helpful folks around here are. Thank you for reading.

 

[GraH]

Why??
Since in Power Query you can do that with a merge. Load that other table also as query. Merge queries, select the second table in the bottom half of the screen. Then you select the column op top and below to replace the lookup. Press ok and then expand the column.
Remember to load the 'lookup query' as connection only.

 

[Mr_Phil]

Why?? Because I am a Clueless Newby. I'm working on my second PQ ever.
Since in Power Query you can do that with a merge. Load that other table also as query. Merge queries, select the second table in the bottom half of the screen. Then you select the column op top and below to replace the lookup. Press ok and then expand the column.
Remember to load the 'lookup query' as connection only.

It (adding an xlookup column to the table made by the query) worked! Woo Hoo!
I will give your method a try as well. Never did a merge and I need to read up on "connection only".
Thank you!