Get the answers you need at Westonci.ca, where our expert community is dedicated to providing you with accurate information. Discover the answers you need from a community of experts ready to help you with their knowledge and experience in various fields. Our platform offers a seamless experience for finding reliable answers from a network of knowledgeable professionals.

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

Sagot :

The option is to Deselect (blank) in the pull-down menu for Customer Sales in the dataset.

How do one delete these rows completely?

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

https://brainly.com/question/24309209