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?
To analyze complaints by the date, you need to extract the date portion from the Logged column. The date format in the Logged column is 'YYYY-MM-DD', which is present at the beginning of the string. By extracting the first 11 characters, you isolate the date portion, allowing it to be transformed into a Date type for analysis while disregarding the unnecessary time information.
Answer C is best approach Split the Logged column by using "at" as the delimiter.
Correct!
Agreed with you Jay
delimiter uses only one character, so "at" is not valid
You can make it by choosing "custom" delimiter
Discordo! Pois a pergunta diz que é apenas pra extrair a informação e, não pra dividir a coluna. A resposta correta é D.
C, You should split the Logged column by using "at" as the delimiter. This will allow you to separate the date and time into separate columns, which will enable you to analyze the complaints by date and use a built-in date hierarchy. Alternatively, you could also use a transformation to extract the date and time from the Logged column and set the data type of the new columns to Date and Time, respectively. Option A is incorrect because it only extracts the last 11 characters of the Logged column, which would not include the date. Option B is incorrect because the data in the Logged column is in a non-standard date format and cannot be directly converted to the Date data type. Option D is incorrect because it only extracts the first 11 characters of the Logged column, which would not include the time.
delimiter uses only one character, so "at" is not valid
You actually can do that if you click on the "Select or enter delimiter" in the "Split Column by Delimiter" window that pops up after you click on "Split Column" in the "Transform" tab on top of your Power BI window. After you select the --Custom-- option from the drop down menu in the "Select or enter delimiter" drop down list, you can write "at" in the text box that appears below the drop down list.
Correct answer
I think _Jay_ is right, C would be the best approach, you can split a column by a delimiter having more than 1 character. If you choose D, you still would have to transform the column to date before you can run the required analysis.
Tested. Only Option C will give a date format column instantly after the split. Extract 11 left character will still leave the column in TEXT format, need one extra step to convert it to date field.
C is correct
time is just not needed you nerds. date is only required. throw the time column of the cliff.
you should split the logged column.
o analyze the complaints by the logged date and utilize Power BI’s built-in date hierarchy, you should apply a transformation to extract the first 11 characters of the Logged column. This will give you the date portion, which can then be used effectively for your analysis
c: as it converts its type to date as well.
Removes the 'at', which in this case is not needed and unnecessarily increases the size of our model
Hello all, I am voting C and not D because I am counting only 10 characters from teh left to extract 2018-12-31 and not 11, so extracting 11 will include a space at the end wont it? Though I tried it in PQE and after the split column applied step, it was changed to date....so I am not sure about the space. Though I understand that using split with "at" delimiter creates and extra column, but the case does not ask us to optimise the model . we must always go with what the question says not general PBI practices.
why does everyone choose C? the questions says "Logged contains the date and time" but you need to analyze by date, so we don't need an additional time column. D is enough
Option D seems weird but it is logically correct. To avoid creating unnecessary 'time' column, you don't need to use split function. I would have been worried about data type, because a column structured as presented in the question would have wrong data type. But the provided answer stated that CSV has no data type. Strange, but I will go with it.
Microsoft Fabric states it is D!
The correct answer is D. Although answers C and D may be correct, answer D is more optimal. When you "Split" columns, it adds a new column, in this case with the time. This causes us to add more data to the data model that we are not going to use.
we can split 2018-12-31 at 08:59. using Space (" ") as delimiter and then will remove column where "at" is present.
The correct answer is definitely C. In the power query editor, you can customized split it by 'at'. Once you do it, it would result in giving you two column, one of them containing the date with the date datatype, and the other containing time with the time datatype. Once you apply and close it, in the power bi report, you can see that you have a date hierarchy.