You import an HR dataset into Power BI Desktop for MDFT Academy. The dataset contains information about employees, departments, and roles, and you want to ensure the data is clean and reliable.
You need to find distinct and unique rows for each column in a dataset appearing in a single view. Which data quality option should you use to achieve this goal?
Choose the correct answer from the options below.
Please select at least one answer!
Correct!
I'm sorry, your answer is not correct.
Explanations for each answer:
Column quality is incorrect. Column quality shows valid, error, or empty values for all columns, not distinct and unique values.
Column profile is incorrect. Column profile analyzes value distribution and unique values for a selected column, not all columns in a single view.
Column distribution is correct. Column distribution displays distinct and unique values for each column in a single view, making it the best option for this scenario.
Custom column is incorrect. Custom column allows you to create a new column using Power Query, not for checking distinct and unique values.