Microsoft Certified: Power BI Data Analyst Associate Practice Mode

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 1

  Select the discount column, Change its data type to Decimal Number and then Replace Errors with 0.05

• 1

  1) Select discount column' 2) Change Data Type to Decimal Number 3) Replace Errors with 0.05. Say a text value was introduced. It will only be flagged as an 'error' when the column datatype is changed to a number. This particular sequence creates 'errors' for all conceivable datatypes current or future.

• 2

  Order: Select the discount column Change its data type to Decimal Number Replace Errors → 0.05 Reason: changing the type first creates the numeric conversion errors; then Replace Errors lets you fill those with 0.05 without removing any rows.