Forum Discussion
Power Query equivalent to Left Join
I am working on a project for sales where there are 4 types of offers and every rep should be making each. I want to see how many of them are doing each kind of offer. For my data, I have a query...
Anonymous,
Just add a custom column.
= Table.AddColumn(Source, "Custom", each Table2)
Hi Anonymous
in Power Query you have the possibility to join two tables by using the 'Merge' feature. In there you can choose different kinds of joins, Left Outher, Inner, Right Outer, Left anti, Right Anti. Have you already tried to use it?
Yes. The issue is for each rep, i need all all the contents of the second table.
Anonymous,
Just add a custom column.
= Table.AddColumn(Source, "Custom", each Table2)