Forum Discussion
Filter creates null values in Power Query in Excel
Hi jaryszek ,
You have selected "Right Outer (all from second, matching from second)" when merging queries. "Right Outer" will keep all rows from the second table. When you filter columns from the first table, the records from the second table will be retained.
You can try to change the Join Type to "Left Outer" in your scenario.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi jaryszek ,
You have selected "Right Outer (all from second, matching from second)" when merging queries. "Right Outer" will keep all rows from the second table. When you filter columns from the first table, the records from the second table will be retained.
You can try to change the Join Type to "Left Outer" in your scenario.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Just a follow up on the solution provided by Icey. It is very similar to what I suggested, but the solution from Icey may still result in null values in the 'right' table. If you don't want ANY null values you can choose INNER join, to only find rows that exist in both tables.
Careful with merges too, as you can add rows of duplicate values (not just NULL) to your data if you're not careful.
See if this post helps with merges: https://radacad.com/how-to-change-joining-types-in-power-bi-and-power-query/?ref=818