Forum Discussion
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...
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.
or
= Table.RemoveLastN(#"Első sorok megtartva", (x)=> List.IsEmpty( List.RemoveMatchingItems( Record.ToList(x),{"",null})))
Unfortunately this is the message I got back: the name Sorted rows1 can't be recognized.
I tried to modify the script: with integration of your proposal. Although there is no syntax error now, but as you cas see, the command is uneffective 😞
most likely your date column is not empty or there is another one that is not empty
