DRAG DROP
-
You use Power Query Editor to preview the data shown in the following exhibit.
You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative effort.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Order is correct, we need to correct the errors first. Thus we select the column and then replace errors then change the data type.
Select Discount > Replace errors with 0.05 > Set Discount type to Decimal
Is it incorrect if I set the Discount type to Decimal before replacing the errors?
Why do we need to change the datatype?
its currently stored as text its a decimal value so store it as a decimal
yes , it is required to change the datatype of the column
This was so logical. No argument for this one.
Can someone explain the reason behind the order of steps 2 & 3? What if the errors are caused by the data type?
The column has data type 'Any' know, which means it does not have any explicit data type definition. You can determine that because of the 'ABC 123' in the top left corner of the column, the symbol for 'Any'. So that cannot cause the errors. Source: https://learn.microsoft.com/en-us/power-query/data-types On top of that, if you would first change the data type, you would be creating additional steps between the problem and the end result. So when troubleshooting, you're working somewhere 'in the middle', and if you expand the error messages, all steps after that will be deleted. So that means you can start again. Just resolve errors immediately.
great explanation
The correct three consecutive actions are: Action 1: Select the discount column. This is the column we need to transform. Action 3: From the discount column, change data type to decimal Number. This step is necessary to work with numeric values. Action 5: Select replace error to replace each error value with 0.05. This will address the requirement of replacing error values with the desired discount value. Action 2: select the price column. Selecting the price column is not relevant to the requirement of cleaning and transforming the discount column. Action 4: From the discount column, change data type to whole number. Changing the data type of the discount column to a whole number is not appropriate since the discount values are decimal numbers, and you want to replace errors with 0.05, which is not a whole number.
De acuerdo con la respuesta
The correct three consecutive actions are: Action 1: Select the discount column. This is the column we need to transform. Action 3: From the discount column, change data type to decimal Number. This step is necessary to work with numeric values. Action 5: Select replace error to replace each error value with 0.05. This will address the requirement of replacing error values with the desired discount value. Action 2: select the price column. Selecting the price column is not relevant to the requirement of cleaning and transforming the discount column. Action 4: From the discount column, change data type to whole number. Changing the data type of the discount column to a whole number is not appropriate since the discount values are decimal numbers, and you want to replace errors with 0.05, which is not a whole number.
are you sure about the order? I mean, if i modify the type after the replacement, isn't the same? Or even better, because you're not causing other problems of types before the casting
This order is correct: - Select the discount column - Change data type to decimal - Select Replace Errors TESTED
Correct
given answers are correct
Yes please. It would be great if someone explain the 5 & 3 answer order. Assuming the answers are 1-5 top to bottom. Could/Should the answer be 3 & 5 instead?
Oh no, I get it now. Of course, you want to get rid of the errors first. :)
The correct three consecutive actions are: Action 1: Select the discount column. This is the column we need to transform. Action 3: From the discount column, change data type to decimal Number. This step is necessary to work with numeric values. Action 5: Select replace error to replace each error value with 0.05. This will address the requirement of replacing error values with the desired discount value. Action 2: select the price column. Selecting the price column is not relevant to the requirement of cleaning and transforming the discount column. Action 4: From the discount column, change data type to whole number. Changing the data type of the discount column to a whole number is not appropriate since the discount values are decimal numbers, and you want to replace errors with 0.05, which is not a whole number.
Correct answer is: Select Discount > Replace errors with 0.05 > Set Discount type to Decimal This sequence does not work in P-BI: Select Discount > Set Discount type to Decimal > Replace errors with 0.05
Change data type last because if the error is relating to the column not being convertable to decimal then that action will fail. If you replace to 0.05 first you are guaranteed it is convertable to decimal.
correct answer