In Power Query Editor, which option shows the percentage of valid records in a column?

In Power Query Editor, which option shows the percentage of valid records in a column?

• A. Column distribution
• B. Column profile
• C. Column quality
• D. Filter by value

Answer: (D)

Power Query Editor shows a column quality indicator that reveals how clean a column is by displaying the percentage of valid records, along with percentages for errors and blanks. This quality view is designed to give a quick snapshot of data reliability for that column, without digging into row-by-row details. The option that corresponds to this metric is the column quality view. The other options serve different purposes: column distribution shows how often values occur and their spread, column profile gives a broader statistical summary and sample values, and filter by value is a filtering tool for selecting rows based on values rather than reporting data quality.

Power Query Editor shows a column quality indicator that reveals how clean a column is by displaying the percentage of valid records, along with percentages for errors and blanks. This quality view is designed to give a quick snapshot of data reliability for that column, without digging into row-by-row details. The option that corresponds to this metric is the column quality view. The other options serve different purposes: column distribution shows how often values occur and their spread, column profile gives a broader statistical summary and sample values, and filter by value is a filtering tool for selecting rows based on values rather than reporting data quality.