Microsoft Power BI Data Analyst — Question 29

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?

Answer options

• A. Apply the Parse function from the Data transformations options to the Logged column.
• B. Change the data type of the Logged column to Date.
• C. Split the Logged column by using at as the delimiter.
• D. Create a column by example that starts with 2018-12-31.

Correct answer: C

Explanation

The correct answer is C because splitting the Logged column by 'at' will allow you to isolate the date, which can then be converted into a proper date format for analysis. Option A is incorrect as using the Parse function without separating the date and time would not properly format the date for analysis. Option B would not work directly because the Logged column contains a time component that must be removed first. Option D does not address the need to separate the date from the time.