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 following format: 201812-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 . Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
C . Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
D . Apply a transform to extract the first 11 characters of the Logged column.
Answer: D
Explanation:
With Power Query you can Split Date and Time into Separate Columns by using a transform.
Reference: https://www.exceljetconsult.com.ng/home/blog/power-query-split-date-and-time-into-separate-columns/
Latest DA-100 Dumps Valid Version with 114 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund