You work for MDFT Pro, a well-known training agency, and you are responsible for analyzing student feedback. 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?
Apply a transformation to extract the first 11 characters of the Logged column is incorrect. Extracting the first 11 characters leaves a trailing space and does not properly split the column, requiring additional transformation before the date can be used in a hierarchy.
Change the data type of the Logged column to Date is incorrect. Changing the data type to Date will fail because the "at" delimiter in the middle of the string prevents Power Query from parsing it as a date.
Apply a transformation to extract the last 11 characters of the Logged column and set the data type of thenew column to Date is incorrect. Extracting the last 11 characters captures the time portion ("08:59"), not the date, and would not enable analysis by logged date.
Split the Logged column by using at as the delimiter is correct. Splitting the Logged column by "at" as the delimiter separates the date portion from the time portion, producing a clean date column that can be typed as Date and used with a built-in date hierarchy.