Forum Discussion
Solved
Filter creates null values in Power Query in Excel
Hi Guys, my DAX is : let
Source = Excel.CurrentWorkbook(){[Name="t_SourceVolumes"]}[Content],
#"Merged Queries" = Table.NestedJoin(Source, {"Topology", "Tier"}, t_VolumeCustomization...
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 Jacek~
Are you able to share screenshots with sensitive info removed/covered?
For these screenshots can you please click on the view tab to turn on the column distribution and show that for both source tables (t_VolumeCustomizationsSource and t_SourceVolumes )
There is no reason I am aware of that a filter step would add rows, so is it possible the null row was just hiding? How many rows in your tables?
Finally, why have you chosen RIGHT OUTER join? If you would like to have no null values, then choose INNER join.
Are you able to share screenshots with sensitive info removed/covered?
For these screenshots can you please click on the view tab to turn on the column distribution and show that for both source tables (t_VolumeCustomizationsSource and t_SourceVolumes )
There is no reason I am aware of that a filter step would add rows, so is it possible the null row was just hiding? How many rows in your tables?
Finally, why have you chosen RIGHT OUTER join? If you would like to have no null values, then choose INNER join.