Exam PL-300 topic 2 question 19 discussion

Answer is wrong, the table shouldn't be transposed, the order should be: 1. Use first row as header 2. Unpivot all columns other than "Measure" 3. Rename "Attribute" to "Year" 4. Change data type of "Year" to date (Date > Year)

To me, 1. Transpose the table 2. Use first row as headers 3. Rename the Measure column as Year 4. Change the data type of the Year column to Date. Yo don't need to unpivot but transpose because you need the measures in columns. Don't you agree?

What the video suggested by below @assettemergaliyev . it is a perfect explanations of this question.

Consider the request: To create visualizations that include all measures in the data over time, you need a Year column, a column of all measures and a column for each measure's values. This allows you to use a line chart to effectively visualize the measures over time. Note that converting a Year value from text to date will result in an incorrect date. The correct approach is as follows: 1. Transpose the table. 2. Use the first row as headers. 3. Unpivot all columns other than "Measure" 4. Rename "Measure" to Year.

in order not have to choose "change the year column to date type", which impact the values of year column, here is the suggested sequence: 1. Use headers as the first row 2. Transpose 3. promote the header 4. rename measure to year. With this approach, we can use data to calculate measure over time. feel free to test this approach!

It is not recommended to convert data type of " Year" to date, it should be number or text, as it might potentially be converted to another date value, example 2023 as 30-Dec-1899 (following Excel's date system)

Answer is wrong. The order should be : 1.Use the First row as Header. 2. Unpivot all the columns other than Measure. 3 Rename the Measure column as Year. 4.change the data type of the year column to date . when you use replace : When placing the first row as a header, the data type changes to numeric and changing it back to string would generate an additional step that is not contemplated in the solution.in this problem should be used unpivot. thanks.

I've created same excel table and imported into my own pbix. I've: 1.-TRANSPOSED the table, 2.- PROMOTED headers, 3.- RENAMED "measure" as "year" and, at this point I'm able to set a visual (line graph) with the three measures year over year Changing data type of {2016, 2017, 2018, 2019, 2020} column to DATE type results in ({08/07/1905, 09/07/1905, 10/07/1905, 11/07/1905, 12/07/1905}) column so, if 4 actions are required here, only other action I can select is to 4.- UNPIVOT other columns than measure. With that 4 actions I still can represent the 3 measures over all years and I guess some custom DAX calculations can be defined to get the YoY calculations

1. Transpose the table 2. Use first row as headers 3. Rename the Measure column as Year 4. Change the data type of the Year column to Date. I tested this and worked

Transpose the table Use the first row as headers Rename the Measure column as Year Change the datatype of the Year column to Date its the correct answer

Answer is correct. I just try on my computer and works perfectly.

I totally agree with ThariCD: 1 - Use the first row as headers (we now have column names) 2 - Unpivot all the columns other than Measure (we have years in one column only) 3 - Rename the Attribute column as Year (we have the year column) 4 - Change the data type of the Year column to Date (I only have a doubt for this step, why an year should be considered as a Date???)

The answer is wrong the table should not be transposed

With Transpose there is an issue to do in one step conversion of Year data type from Int to Date (it has to be done in 2 steps int->text->date) and it results in 5 steps, not 4. IDK the answer here.

• 1. Transpose the table • 2. Use first row as headers • 3. Rename the Measure column as Year • 4. Change the data type of the Year column to Date.

The given answer is correct.

Transpose Use the first rows as headers Rename the measure as year Change the data type of the year column