You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
• First name
• Last name
• Email address
• State/Region
• Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Open the Advanced Editor.
B. Select Column quality.
C. Enable Column profiling based on entire dataset.
D. Select Column distribution.
E. Select Column profile.
Explanation:
Data Profiling, Quality & Distribution in Power BI / Power Query features
To enable these features, you need to go to the View tab à Data Preview Group à Check the following:
• Column quality
• Column profile
• Column distribution
• Column profile
Turn on the Column Profiling feature.
• Column distribution
Can use it to visually realize that your query is missing some data because of distinct and uniqueness counts.
https://www.altentertraining.com/microsoft/power-bi/column-profiling-is-good/