Power BI Data Analyst (PL-300) · Free practice question 1 of 12
Column From Examples
A Contacts query at Birchfield Events has a FullName column such as "Okafor, Adaeze". The analyst wants a new column that shows the first name only, and she would rather type two or three expected results than write M code. Which Power Query feature should she use?
- A.Add Column > Column From Examples
- B.Transform > Detect Data Type
- C.Home > Keep Rows
- D.Add Column > Index Column
Show answer and explanation
Correct answer: A. Add Column > Column From Examples
Why: Column From Examples generates the transformation logic from sample output values that you type, and shows the M it builds so you can check it. An index column adds sequential numbers, Detect Data Type only sets column types, and Keep Rows filters rows rather than deriving text from another column.