Forum Discussion

jaryszek's avatar
jaryszek
Super User
5 years ago
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...
  • Icey's avatar
    Icey
    5 years ago

    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.

Icey's avatar
Icey
Community Support
5 years ago

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.