ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam
Go to Exam

Exam DA-100 topic 1 question 26 discussion

Actual exam question from Microsoft's DA-100
Question #: 26
Topic #: 1
[All DA-100 Questions]

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 measures
Which 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:

Show Suggested Answer Hide Answer
Suggested Answer:
Reference:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
Model the Data
by Learny at April 30, 2021, 11:19 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
DKojen
Highly Voted 4 years, 2 months ago
1. Use the first row as headers 2. Unpivot all the columns other than Measure 3. Change the column attribute to year 4. Change the datatype of year to date
upvoted 315 times
bunilggg
3 years, 11 months ago
SAME AS MY ANSWER
upvoted 1 times
...
Bigmeat123
4 years ago
I also agree, tested and it works perfectly.
upvoted 2 times
...
berserkguts
3 years, 11 months ago
Tested a few mins ago, THIS IS THE ANSWER
upvoted 2 times
...
IBM11
3 years, 11 months ago
This is correct. I just tested it.
upvoted 3 times
...
Load full discussion...
...
Crim
Highly Voted 4 years, 1 month ago
I just did the test. Answer is : 1 - Transposse 2- first row as header 3- rename Measure to Date 4- Change the datatype of year to date
upvoted 147 times
ajinnadh
4 years, 1 month ago
is that correct?
upvoted 2 times
ajinnadh
4 years, 1 month ago
Yes i have tested , this is correct
upvoted 5 times
...
Prafvik
4 years, 1 month ago
No. You just cant rename Measure column becuz it clearly states in question that Measures need to be visualized So answer should be Use the first row as header Unpivot columns other than Measure Rename attribute column to Year Change Data type of Year column to Date
upvoted 34 times
toaldoe
3 years, 7 months ago
i concur with this.
upvoted 1 times
...
jakup123
4 years, 1 month ago
this is the correct answer
upvoted 5 times
...
...
...
Nurgul
3 years, 4 months ago
I've tested this. it's correct. Using this table we can calculate year-over-year change of all measures.
upvoted 2 times
...
bankijey
4 years, 1 month ago
I agree with this solution
upvoted 1 times
...
Tomasz1989
3 years, 1 month ago
Why Transpose? It's Redundant step, doesn't change anything.
upvoted 1 times
...
Load full discussion...
...
Michcat
Most Recent 2 years, 3 months ago
Answers should NOT be like UNPIVOT because unpivot only applies to dimensions, not measures. Only thing technically .. when UNPIVOT measures, what data-type of the value column you are going to set ?
upvoted 1 times
...
Mobita3000
2 years, 4 months ago
https://youtu.be/0sci44xnto0 Check this video to remove all confusion
upvoted 4 times
ypnxcat
2 years, 2 months ago
Very clear. Thanks!
upvoted 1 times
...
...
LucianaFS
2 years, 6 months ago
I've tested and the correct answer is: Transpose, First row as header, unpivot, rename de measure as year.
upvoted 1 times
...
Khanna_Puru_1
2 years, 10 months ago
1) Transpose the table 2) Use first row as headers 3) Unpivot the table (as per year) 4) Rename the Measure column as Year This helped to make the fact table.
upvoted 1 times
...
AnkitDeswal
2 years, 10 months ago
Correct answer is: 1. Transpose the table 2. Use first row as header. 3. Unpivot all the columns other than measure. 4. Rename the measure column as year. Incorrect Answers, 1. Measure/Year column contains only the year value, so it should be a whole number type, if we change it to date type, we'll get incorrect values. 2. We don't have to rename the Attribute column to year as after unpivoting, it will contain the following 3 fields (Revenue, Overheads, Cost of Goods) which is not the year.
upvoted 1 times
...
ptmk
2 years, 11 months ago
@DKojen you cannot change a datatype to year, I tried the steps described in the answer and they are correct
upvoted 1 times
eckip
2 years, 9 months ago
You can change the datatype to date and it works.
upvoted 1 times
...
...
mlfattori
2 years, 11 months ago
Probado con un ejemplo en Power BI: 1. Use the first rows 2. Unpivot all the columns other than Measure 3. Rename the Attribute columns as Year 4. Change the data type of the Year column to Date
upvoted 1 times
...
Mvgupta
2 years, 11 months ago
So, what is the exact order, totally confused after reading the discussions.
upvoted 1 times
VeronicaM
2 years, 11 months ago
Correct answer: 1. Transpose 2. Use first row as headers 3. Unpivot 4. Rename measure to Date As others said it is not actually needed to unpivot, as you can later create measures to have in the visuals. However, the other options are wrong and changing the type of year column to Date will give wrong results.
upvoted 1 times
...
...
CreateSiteCollection
3 years ago
Change the datatype of year to date require you manually correct each value 1 by 1. I don't think it is correct
upvoted 1 times
...
KetanT
3 years ago
Yes its confirmed and verified personally...it goes like this, 1. Transpose 2. Use first row as header. 3. Unpivot all the columns other than measure. 4. Rename the measure column as year. Datatype change karne jaoge to "Din men taare dikh jaayenge"
upvoted 4 times
Zered
3 years ago
Have tested it as well. This is the right sequence, 1. Transpose 2. Use first row as header. 3. Unpivot all the columns other than measure. 4. Rename the measure column as year.
upvoted 2 times
...
...
Franz58
3 years ago
I created an example. I think each measure should go into a different column, and we need traspose for that. With unpivot we get different measures in the same column. The solution seems to be as below, but the problem is that converting the Year column to date does not give a correct date. 1 - Transpose 2- first row as header 3- rename Measure to Year 4- Change the datatype of year to date
upvoted 1 times
...
claudeaboki
3 years ago
I just tested this and it works 1.Use first row as headers 2. Unpivot all the columns other than Measure 3.Change the column attribute to year 4. Change the datatype of year to date
upvoted 2 times
...
SamanFeroze
3 years ago
Tested Transpose Use the first row as header Unpivot Unpivot all the columns Rename the attribute column as Year
upvoted 2 times
...
kelibanlangen
3 years, 2 months ago
here is the correct ans！ Transport the table； Use the first row as headers； Rename the Measure column as Year； Change the datatype of year to date
upvoted 3 times
...
kelibanlangen
3 years, 2 months ago
DKojen 's answer was worng obviously！
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel