What should you do in Power Query Editor?

Posted by: Pdfprep Category: DA-100 Tags: , ,

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.

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

Leave a Reply

Your email address will not be published.