Câu 24: PL-300: Microsoft Power BI Data Analyst

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?

1. A. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
2. B. Change the data type of the Logged column to Date.
3. C. Split the Logged column by using at as the delimiter. — đáp án hiện tại
4. D. Apply a transformation to extract the first 11 characters of the Logged column.