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?

A. Change the data type of the Logged column to Date.

B. Split the Logged column by using at as the delimiter.

C. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.

D. Apply the Parse function from the Date transformations options to the Logged column.








 

Suggested Answer: C



This question is in PL-300 Exam
For getting Microsoft Power BI Data Analyst Associate Certificate