Forum Discussion
Power Query merge partially overlapping queries without nulls
I have two queries from two different sources. There are a couple overlapping columns from each that i'm attempting to use to combine them into one table. Basically I need all the info from both in o...
lbendlin
Super User
Super UserThe best you can do is a full outer join.
No matter what I try, i can't associate an invoice to something with no Actual data. How can I accomplish this?
Well, it is called Reality for a reason. If there are no actuals then there is no invoice.