What should you do in Power Query Editor?

You need to address the data concerns before creating the data model.

What should you do in Power Query Editor?
A . Select Column distribution.
B . Select the sales_amount column and apply a number filter.
C . Select Column profile, and then select the sales_amount column.
D . Transform the sales_amount column to replace negative values with 0.

View Answer

Answer: D

Explanation:

Scenario: Data Concerns

You are concerned with the quality and completeness of the sales data. You plan to verify the sales data for negative sales amounts.

How to convert negative numbers into positive numb, editor and right click, select

transform, and choose absolute value. That would give the positive number outcome you’re looking for.

Reference: https://www.xspdf.com/resolution/50510644.html