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

[akhaliq7]

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:

[BA_Pete · Accepted solution]

Hi @akhaliq7 ,

You can filter like this:

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

Pete