Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You are cleaning a 'Sales' table in the Power Query Editor. The 'DiscountPercentage' column, which should contain numerical values, has a data type of 'Any'. It contains numbers, null values, and the text string "N/A". Your goal is to convert this column to a 'Decimal Number' type for calculations. You must replace both the null values and the "N/A" strings with 0 and ensure no rows are lost. Which sequence of steps is the most effective way to achieve this?

  • Filter the column to exclude "N/A" and null values. Then, change the column data type to 'Decimal Number'.

  • Use the 'Fill Down' transformation to handle the null values. Then, use 'Replace Values' to replace "N/A" with 0.

  • Change the column data type to 'Decimal Number'. Then, use the 'Remove Errors' feature to eliminate any rows that failed the conversion.

  • Use 'Replace Values' to replace "N/A" with 0. Use 'Replace Values' again to replace null with 0. Finally, change the column data type to 'Decimal Number'.

Microsoft Power BI Data Analyst
Prepare the data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot