Question

You import a supplier price list into Power Query. The Unit Cost column is typed as Decimal Number, but several rows show Error values because the source contained text like 'N/A' where a price was missing. Business rules state that missing prices should be treated as zero so the column can still be aggregated. Which Power Query approach correctly resolves these errors while keeping the column numeric?

Accepted Answer

Select the Unit Cost column and use Transform > Replace Errors, entering 0 as the replacement value

Answer

Use Home > Remove Rows > Remove Errors to drop every row that contains an error

Answer

Change the column data type back to Text so the error values disappear

Answer

Use Transform > Replace Values to replace 'N/A' with 0 in the Unit Cost column