This topic contains 3 replies, has 2 voices, and was last updated by 
-
Posts
-
Hello, I have two data tables. A current and a prior. I’m trying to perform a full outer join in power query that will enable me to calculate if an account is in prior but not current and vice versa. It will also allow me to calculate the change in amounts if it is in both. I can accomplish this in SQL but am struggling to do so via power query. The excel file attached is a sample of the current and prior tables. Any help would be appreciated.
Carl,
Attached is one of the files used to perform a full outer join between prior and current.
Steps taken include: explicitly naming each table, creating power queries for each named table and then loading each as connection only.
Used the Merge feature to combine the two tables, with the join option of full outer join.
Before merging can complete, you need to specify the columns in each table to join. After combining the tables, you still need to expand the second table (the right-side table).
Tom
Thanks looks like it does what I need. My question is how did you accomplish it with the powerquery applied steps? Did you have to write the dax for the Expanded NewColumn step? I can’t figure out how you did that.
Nevermind I found the Expand NewColumn button on the Transform ribbon. Sorry should have looked harder or googled! Thanks for your help!
The topic ‘Full Outer Join with Conditions’ is closed to new replies.