Answered

Westonci.ca is the best place to get answers to your questions, provided by a community of experienced and knowledgeable experts. Experience the convenience of getting accurate answers to your questions from a dedicated community of professionals. Explore comprehensive solutions to your questions from knowledgeable professionals across various fields on our platform.

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

Thanks for stopping by. We are committed to providing the best answers for all your questions. See you again soon. Thanks for using our platform. We aim to provide accurate and up-to-date answers to all your queries. Come back soon. Keep exploring Westonci.ca for more insightful answers to your questions. We're here to help.