Forum Discussion
Solved
Power Query Column that looks up value in another table based on 2 criteria
Hi, Thank you in advance for any help. I spent several hours trying to work this out and have hit a dead end. I have a table called "Planning", which contains all of our future planned project ...
Hi Jamez_P ,
You can do a merge on Power Query based on several columns when you merge the two tables you just need to pay attention to the order you select the columns so that the sorting of the merge is the same.
MFelix
Super User
Super UserHi Jamez_P ,
You can do a merge on Power Query based on several columns when you merge the two tables you just need to pay attention to the order you select the columns so that the sorting of the merge is the same.
Thanks, I can't believe I forgot this was a possibility. For any other people with the same problem, you hold ctrl and select the columns in the order and little 1,2,3 etc. appear on each column in the merge window.