Adding through multiple criteria

Hi Syndicate_Admin 

About your first criteria ,you can merge the two table like this in power query .

Then expand table like this  :

Now table is like this

Regarding to your second criteria,base on the upper ,still merge

Then expand like this:

Now the table is like this:

And about the third criteria , same as upper ,but this time merge base on key1 field

Best Regards,

Community Support Team _Isabella

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.