Question

You are preparing a sales table in Power Query. The 'DiscountAmount' column contains many null values because discounts were only recorded for promotional orders. A downstream step sums 'DiscountAmount' with 'ShippingFee' to create a 'TotalDeductions' column, but the resulting column shows null for every row that had a null discount. You must ensure that orders without a discount are treated as having a zero discount so the addition produces correct totals. What should you do?

Accepted Answer

Use the Replace Values transform on 'DiscountAmount' to replace null with 0 before the addition step

Answer

Use Remove Rows > Remove Blank Rows to delete rows where 'DiscountAmount' is null

Answer

Change the data type of 'DiscountAmount' to Whole Number so nulls become zero automatically

Answer

Apply Remove Errors on the 'TotalDeductions' column after the addition step