Question

You have a filtered dataset for Customer Sales with some null value rows. You want to remove these rows completely. How will you do this?

Answer 1

Answer:

Deselect (null) in the pull-down menu for Customer Sales in the Power Query Editor.

Deselect (blank) in the pull-down menu for Customer Sales in the dataset.

Change the filter so null value rows are not displayed.

Place your cursor to the left of the rows, and then select Delete.

Explanation:

Answer 2

Answer:

1

Explanation: