You have the following table. You plan to use [Month Name] as the axis in a PivotChart. You need to ensure that whenever [Month Name] is used in a chart, the months are displayed chronologically by default. What should you do?
A.
Add a calculated column named [ID] that uses the [Month Name]&[Month Number] DAX formula
Answer should be D. The reference link is dead but you can search for the second half of the link description and find a copy of the article that clearly shows the answer is D.
D.
Perform it in the Data Model.
http://excelunplugged.com/2013/04/16/sorting-months-chronologically-and-not-alphabetically-in-a-pivot-table-report-based-on-power-pivot-data/
D. correct
A. wrong (IMO)
the [ID] column since the first part of the concatenation is the month name, when sorted the result will be same as [Month Name]
from the link:
To Sort Months Chronologically, you need a Power Pivot Data Model and a Date field. Next you should get Month names and Month numbers by using Formulas. Finally you can then use Sort By Column in Power Pivot.
Answer is D
This section is not available anymore. Please use the main Exam Page.70-779 Exam Questions
Log in to ExamTopics
Sign in:
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.
GST0101
Highly Voted 5 years, 8 months agoPowerBIconsultant12
4 years, 8 months agoimran
Highly Voted 5 years, 8 months agoCDL
Most Recent 4 years, 8 months agohroumani
4 years, 9 months agostv
4 years, 11 months agoBronik
4 years, 12 months agoCibrevN
5 years agoChikhalsouk
5 years, 1 month agoSN22
5 years, 4 months agomohroshdy
5 years, 6 months agodinessa
5 years, 7 months agor8d1
4 years, 11 months agoTadeuMansi
5 years, 7 months ago