The option is to Deselect (blank) in the pull-down menu for Customer Sales in the dataset.
<h3>How do one delete these rows completely?</h3>
If a person is working in the Query Editor (that is the place where one can get data, before you close and apply).
The right thing to do is to select the column that you want to use to check for nulls and when the values you are looking at is really blank, you can then click the drop-down and delete Rows in the ribbon, then one can click the option of Remove Blank Rows.
See full options below
Select an 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.
Learn more about dataset from
brainly.com/question/24309209
