Forum Discussion

akhaliq7's avatar
akhaliq7
Post Prodigy
3 years ago
Solved

Want to filter if column is null in two two columns sample data incl.

I have a dataset whereby if both the columns Calls Attended % and Files Approved % have nulls then I want to filter the rows, I don't want to filter if one of the columns have a null value, As you can see in the below image row 15 would be filtered once the solution is applied.

 

Implementing this problem in power query.

 

Sample Data:

 

Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi akhaliq7 ,

     

    You can filter like this:

    Table.SelectRows(
    previousStepName,
    each List.Sum( {[Calls Attended %], [Files Approved %]} ) <> null
)

     

    Pete

1 Reply

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    Hi akhaliq7 ,

     

    You can filter like this:

    Table.SelectRows(
    previousStepName,
    each List.Sum( {[Calls Attended %], [Files Approved %]} ) <> null
)

     

    Pete