Exam PL-300 Microsoft Power BI Data Analyst

Access More Questions

You have a CSV file with user complaints in it. The file has a column called Logged in it. Each complaint's log entry includes the date and time that it happened. The information in Logged is formatted as follows: 2018-12-31 08:59. You must be able to use an internal date hierarchy and the logged date to assess the complaints. What ought you to do?

Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date. 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. Change the data type of the Logged column to Date. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

Correct Answer:

Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.

Access more questions from this quiz

Continue to Exam PL-300 Microsoft Power BI Data Analyst for more practice questions and the full quiz experience.

Access More Questions