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.
pls try this
= Table.SelectRows( #"Első sorok megtartva",
(x)=> not List.IsEmpty( List.Select( Record.ToList(x),(x)=> x<>"" and x <> null) ))
Hello Ahmedx!
Firstly thank you for your support. Unfortunately a syntax error popped up:
"Első sorok megtartva"
can't be recognized by PBI. Honestly I don't know why. For me it is clear. When I tried to integrate your script after comma, there was no syntax error, but the command was as unneffective as the other solution