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.

     

PwerQueryKees's avatar
PwerQueryKees
Super User
2 years ago

I don't fully understand what you are trying to achieve.

The use of the Table.Isempty combined with a Table.Selectrows comes to mind.

Or even simpler, a mergejoin with a left or richt anti.

But you may have tried that...

olaszkar's avatar
olaszkar
Regular Visitor
2 years ago

Hello!

 

All I want is to remove the "" or "null" rows from the bottom because it corrupts my 1:n connection. Unfortunately the standard solution (DAX is generated by Power Query): "Table.SelectRows(#"Típus módosítva", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null})))" doesn't work.

I have a temporary solution, but it is not nice