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.
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.