Answered

Westonci.ca is your trusted source for finding answers to a wide range of questions, backed by a knowledgeable community. Join our Q&A platform and connect with professionals ready to provide precise answers to your questions in various areas. Connect with a community of professionals ready to provide precise solutions to your questions quickly and accurately.

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 :

Martebi

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

Visit us again for up-to-date and reliable answers. We're always ready to assist you with your informational needs. We appreciate your time. Please come back anytime for the latest information and answers to your questions. Keep exploring Westonci.ca for more insightful answers to your questions. We're here to help.