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?
正解:C
Simply create a custom table in Power Query, enter the date shown in the question into a column called Date, and then Split it by a delimiter. No need for spaces on either side of "at" Power BI takes care of the rest: = Table.SplitColumn(#"Changed Type", "Date", Splitter.SplitTextByDelimiter("at", QuoteStyle.Csv), {"Date.1", "Date.2"}) It will even automatically change the type to Date: = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Date.1", type date}, {"Date.2", type time}})