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

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam
Go to Exam

Exam 70-778 topic 1 question 19 discussion

Actual exam question from Microsoft's 70-778
Question #: 19
Topic #: 1
[All 70-778 Questions]

You are creating a report in Power BI Desktop.
You are consuming the following tables.

Date[Date] is in the mm/dd/yyyy format. Date[DateKey] is in the ddmmyyyy format. Date[MonthNumber] is in the mm format. Date[MonthName] is in the mmm format.
You create the report shown in the exhibit. (Click the Exhibit button.)

You need to ensure that the months appear in the order of the calendar.
How should you sort the MonthName column?

  • A. by MonthNumber
  • B. ascending
  • C. descending
  • D. by DateKey
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
References:
http://ppmworks.com/sorting-month-names-chronologically-in-microsoft-power-bi-reports/
by AnetaK at July 17, 2019, 10:06 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
AnetaK
Highly Voted 5 years, 9 months ago
How can a full month name be displayed, if MonthName is in mmm format?
upvoted 14 times
...
Faizal
Highly Voted 5 years, 4 months ago
Correct. A
upvoted 9 times
...
tamin
Most Recent 4 years, 4 months ago
Answer "A" is correct. The question says "You need to ensure that the months appear in the order of the calendar". So if you sort through monthNumber in asceding mode will be correct.
upvoted 2 times
...
CDL
4 years, 6 months ago
correct. same Q as 779.
upvoted 1 times
CDL
4 years, 6 months ago
sort Month Name (MMMM) by Mon_Num#
upvoted 1 times
...
...
Satyapn9
4 years, 9 months ago
Yes, Correct Answer is A. I did the exercise and working fine. Sorting the Month Name by Month Number to bring Month Name to calendar sequence.
upvoted 3 times
...
selinahk
4 years, 11 months ago
what about datekey? i think it can also meets the requirement.
upvoted 1 times
p_eloy
4 years, 10 months ago
you can't sort by datekey because 20200101 and 20200102 are both related to january, so Power BI won't know what is the correct order. Unless the date key was in the 202001 format.
upvoted 1 times
...
...
maryl
5 years, 2 months ago
Disagree with A. Sorting by month # would have January first in list not April. Monthname is meant to be a string and by default would be alphabetical, ascending.
upvoted 1 times
JideID
4 years, 11 months ago
You sort MonthName by Month Number if you want month name to appear chronologically. A is correct.
upvoted 2 times
...
Clodar
5 years, 2 months ago
The exhibit is wrong, that's what the question is asking, how to make sure the months are sorted from Jan to Dec, and answer A is the correct one.
upvoted 9 times
maryl
5 years, 2 months ago
you are right. missed that part. thanks
upvoted 2 times
...
...
...
rhsdeal
5 years, 8 months ago
Anetak - good catch, I believe the answer is still correct given the flaw in the ?
upvoted 6 times
...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago