Forum Discussion
Solved
M Power Query: Removing entire rows based on condition
I want to remove entire rows IF both horizontally adjacent cells in the last two columns are empty (hence rows 4, 6, 7, 9 should be removed). How can I do this? Not sure by the way whether I should d...
HI RafaelKnuth
With Power Query...
You can add a Custom Column....>>>>then filter out the Null values in that column and then delete this Custom Column
HI RafaelKnuth
With Power Query...
You can add a Custom Column....>>>>then filter out the Null values in that column and then delete this Custom Column
Hi Zubar
Do you mean that if I load 100,000 row table to power BI
if I want to delete from Row 5 till 100,000 , I can just write bSe on those script you share with me ?