PL-300 Exam - Question 51

Question

DRAG DROP -You are preparing a financial report in Power BI. You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit. You need to prepare the data to support the following:✑ Visualizations that include all measures in the data over time✑ Year-over-year calculations for all the measuresWhich four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select and Place:.

Examice · Accepted Answer

Reference:https://docs. microsoft. com/en-us/power-query/unpivot-column.

ThariCD · Answer

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)

jorv86 · Answer

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?

Usm_9 · Answer

WAS ON THE EXAM 02 03 2024

Mo2011 · Answer

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

DANIEL · Answer

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

ikramus · Answer

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

kay1101 · Answer

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.

0e18c76 · Answer

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

greenlever · Answer

The given answer is correct.

Chellz · Answer

Was on Jun 8, 2024 exam

DANIEL · Answer

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

MANANDAVEY · Answer

1. Transpose
2. first row as header
3. Rename the measure coloumn as year
4. Change the datatype

100% TESTED SEQUENCE in PowerBI !!!

rdwn_akml · Answer

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

SIH007 · Answer

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?????

SeethaG · Answer

•	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.

agelee · Answer

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.

hayleyxiong33 · Answer

The answer is wrong the table should not be transposed

PL-300 Exam - Question 51

Discussion