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?

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

Sorry, but the last step is wrong, if you change the year to datatype date you would get 17th July, 1905. Actually my problem is: which 4th option do I select when all remaining options are wrong?????

The 3rd step is wrong. You do not need to unpivot. The solution must be: 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. This is really a tricky questions and most of us tend to go immediately to "unpivot other columns". The key here is to check the data carefully. And if you noticed on the first column, besides the first row which is measure, the other rows are all fields as well. So transpose instead of unpivot. Please check: https://www.youtube.com/watch?v=0sci44xnto0

TRANSPOSE the table Use first row as header Rename the measure column as Year Change the data type of the year column to Date

Tested in Power BI, Both unpivot and transpose worked. I think the answer depends on the desired format of outcome table. If you want a 3 * 15 (row * col) table, with each measure and year to be a dependent row, then unpivot. If you want a 5 * 4 (row * col) table, with measures(revenue etc.) are columns and year in the row, then transpose.

1. Transpose 2. first row as header 3. Rename the measure coloumn as year 4. Change the datatype 100% TESTED SEQUENCE in PowerBI !!!

WAS ON THE EXAM 02 03 2024

answer is right; when you transpose you obtain the correct order requested by the question; year to products 2016-product1; 2016-product2; 2016-product3; and so on when you unpivot, you obtain a different order; product to years 2016-product1; 2017-product1; 2018-product1; and so on

Tested in PBI Desktop with the exact same excel sheet; Transpose : first column values become first row and each row contains its respective values Use first Row as Headers: first row containing values from first excel column, promoting that first row make it a row header : correct. Pay attention to an automatic applied step changing types on the fly too such as: = Table.TransformColumnTypes(#"Promoted Headers1",{{"Measure", Int64.Type}, {"Revenue", type number}, {"Overheads", type number}, {"Cost of Goods", type number}}) Unpivot Other Columns (having measure column selected): creates 3 columns : Measure - Attribute - Value Measure column contains YEAR values only Rename Measure Column to YEAR : because it's the data in it. Now you can filter by attributes and see the evolution year by year

1. Use first row as header 2. Unpivot all columns other than "Measure" 3. Rename "Attribute" to "Year" 4. Change data type of "Year" column to Date Reference: https://docs.microsoft.com/en-us/power-query/unpivot-column

To solve the problem, it needs only 3 steps 1) Use first row as header 2) Unpivot all columns other than "Measure" 3) Rename Attribute to Year But if we go with 4 steps as asked in the question, then we need to do the below sequence 1) Transpose 2) Use first row as header 3) Unpivot all columns other than "Measure" 4) Rename "Measure " to "Year"

The answer is correct if you follow through with the step. (1) Transpose the table. Results: Header: Column 1 | Column 2 | Column 3| Column 4 First Row: Measure | Revenue | Overheads | COGS Next Row: YEARS | Value of R | Value of OH | Value of COGS (2) Use First Row as Header Results: Header: Measure | Revenue | Overheads | COGS Rows: YEARS | Value of R | Value of OH | Value of COGS (3) Rename Measures to Year Results: Header: Year | Revenue | Overheads | COGS Rows: YEARS | Value of R | Value of OH | Value of COGS (4) Unpivot Other Columns Results: Header: Year | Attribute| Value Rows: YEARS | Measure | Values Test the results: (1) Create a table matrix. (2) Place the YEAR as Row (3) Place the Attributes as Column (4) Place the Values as value. Results: You get a Year over Year report for Revenue, Overheads, and COGS.

I've checked on PBI. The correct order is Use first row as header. Unpivot all columns other than "Measure" Rename "Attribute" to "Year" Change data type of "Year" to date

The key to this question is what data type(text or number)of the year value can be converted to a date type. In the suggested answer, after transposing, all the year values are still numbers, which when changed into date type, will use the Excel sequential serial number method, so you get 1905-07-08. In the most voted answer, the year values were first promoted as header, and after unpivoting became text values under the column "Atrribute". Text "2017" will be converted to "2017-01-01" when changed to date type.

Amazing at how often the suggested answer is incorrect. The CORRECT answer is: 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