Microsoft
70-779 · Question #117
You have the following tables in a data model. You create a PivotTable to display SaleAmount by Month. A sample of the results are shown in the following table. You need to ensure that the data…
The correct answer is A. In the data model, modify the Sort By Column setting for Date[Month Year]. You should use "Sort by column" for the [Month Year].
Model data by using Microsoft Excel
Question
You have the following tables in a data model. You create a PivotTable to display SaleAmount by Month. A sample of the results are shown in the following table. You need to ensure that the data appears in chronological order. What should you do?
Exhibit
Options
- AIn the data model, modify the Sort By Column setting for Date[Month Year]
- BFrom PivotTable Fields, add Date[Year] to the Rows area
- CIn the data model, modify the Sort by Column setting for Sales[Date]
- DFrom PivotTable Fields, modify the Field Settings for Date[Month Year]
How the community answered
(48 responses)- A75% (36)
- B4% (2)
- C6% (3)
- D15% (7)
Explanation
You should use "Sort by column" for the [Month Year].
Topics
#Sort By Column#data model#chronological order#PivotTable
Community Discussion
No community discussion yet for this question.