Forum Discussion

olaszkar's avatar
olaszkar
Regular Visitor
2 years ago
Solved

List.RemoveMatchingItems function doesn't work

Hello ladies & Gents!   I have the following problem. I have a Power BI visualization where 2 excel tables are connected with 1:n connection. In order to make it work I need to eliminate all rows w...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi olaszkar ,

     

    We often remove nulls in Power Query by the following ways:

    1.Apply a filter to the column so that it does not include nulls.

     

    2.Regardless of the column, you remove rows that are blank. Start menu. Remove Rows option, Remove Blank Rows option.

     

    Best Regards,

    Stephen Tao

     

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

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi olaszkar ,

 

We often remove nulls in Power Query by the following ways:

1.Apply a filter to the column so that it does not include nulls.

 

2.Regardless of the column, you remove rows that are blank. Start menu. Remove Rows option, Remove Blank Rows option.

 

Best Regards,

Stephen Tao

 

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

 

olaszkar's avatar
olaszkar
Regular Visitor
2 years ago

Hello Stephen!

 

Yes, your solution worked. Can you please tell me the logic behind? (Why did it worked? Why does the filtering necessary?)

I'd appreciate it!

 

Br

Karoly