Answered

At Westonci.ca, we connect you with experts who provide detailed answers to your most pressing questions. Start exploring now! Our platform provides a seamless experience for finding precise answers from a network of experienced professionals. Explore comprehensive solutions to your questions from a wide range of professionals on our user-friendly 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

We hope our answers were helpful. Return anytime for more information and answers to any other questions you may have. Thanks for using our service. We're always here to provide accurate and up-to-date answers to all your queries. Westonci.ca is committed to providing accurate answers. Come back soon for more trustworthy information.