Forum Discussion
RenateBK
Helper II
Helper IIHow to remove rows where data is missing in specific columns (without using filtering)
Hello, I have a dataset which is not perfectly cleaned and some rows with wrongful data has been included. I need to remove these specific rows to avoid confusion and using the "filter" functio...
ITManuel
Responsive Resident
Responsive ResidentHi RenateBK ,
from what I know you can only "remove" rows by filtering them out. What is the issue with filtering blanks on the specific column?
You can do that either in PowerQuery or in DAX for the calculations you want to carry our, thus all rows in which there are blanks in the specific column are not present because ignored.
Br
RenateBKHelper II
Helper IIThe main issue is mostly just consistency as there is a risk that it will be forgotten because I have to filter it out in 10+ different data sets.
However, I think I managed to come up with an easy solution. I simply sort the column with the missing data from "a to z" then I can remove x amount of top rows that's empty without any issue.
Br