In using Power Query, you notice that a field of data is not joining with data that appears the same. You have already removed trailing and leading spaces. What cleaning command should you consider next?Select an answer:CLEANTRIMREPLACE ERRORSREPLACE VALUES

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?Select an answer:Deselect (null) in the pull-down menu for Customer Sales in the Power Query Editor.Change the filter so null value rows are not displayed.Place your cursor to the left of the rows, and then select Delete.Deselect (blank) in the pull-down menu for Customer Sales in the dataset.

Power Query - Blanks & nullsMissing, blank or null values can cause a lot of problems in Power BI, and in other business intelligence tools.Match the names to the definitions:Review Later Nulls BlanksRepresents a text string with zero characters. This zero length text string is considered a valueRepresents the absence of all data. No data has been collected or entered

Clean function in power query is found in ------tab?Options :HomeTransformAdd columnView

Fill in the blank with the correct answer:Power PivotPower Query Editor3D Maps (Power Map)Relationship builderblank1 - Word AnswerWrite your response here... : is the tool that we should use to remove fields and format data when importing.

James wants to perform an Append Query based on the column title in two tables and uses the merge query function in Power Query.Question 24Select one:a.Trueb.False