Forum Discussion

RenateBK's avatar
RenateBK
Icon for Helper II rankHelper II
3 years ago

How 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...
Need Help
ITManuel's avatar
ITManuel
Icon for Responsive Resident rankResponsive Resident
3 years ago

Hi 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

  • RenateBK's avatar
    RenateBK
    Icon for Helper II rankHelper II
    3 years ago

    The 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