What should you do?

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the fol-lowing 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 . Create a column by example that starts with 2018-12-31.
B. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
C. Apply a transformation to extract the first 11 characters of the Logged column.
D. split the Logged column by using at as the delimiter.

View Answer

Answer: C

Explanation:

According to Microsoft Certified: Power BI Data Analyst Associate1, Power Query Editor is a tool that lets you connect to one or many data sources, shape and transform the data to meet your needs, then load that model into Power BI Desktop2.

One of the transformations you can perform in Power Query Editor is extract date from text, which creates a date value from a textual representation3.

For example, given a text column like this:

Logged

2018-12-31 at 08:59

2019-01-01 at 09:15

You can extract the date part by using the Date.FromText function with a specific format4.

The result will be:

Logged

Date

2018-12-31 at 08:59

2018-12-31

2019-01-01 at 09:15

2019-01-01

This makes it possible to use a built-in date hierarchy for analysis.