Remove the rows when both of the column is null

[NickProp28]

Dear Community,

I retrieved data from company DB, but since its huge data and lots of information. So I did an example in excel file then import to BI.

Here's my data set example:

I want to remove the rows which consignee and consignor column is having null value. (If not remove, it will affect my later calculation part)

I try to use query editor remove 'null' in Consignee, but in result all the null in Consignee has been remove while there might have data in Consignor. 

Here's the pbix: https://ufile.io/govbkbdh

Grateful for any help & thanks for the attention. 

[Vera_33 · Accepted solution]

Hi @NickProp28 

You want to remove both columns are null, insert a step after your current step on the right Applied Steps

Table.SelectRows( yourPreviousStep, each not ( [yourColumn1] = null  and [yourColumn2] = null))