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.
C. Enable Column profiling based on entire dataset.
D. Select Column distribution.
E. Select Column profile.
E. Select Column profile.
