nerdexam
Microsoft

70-778 · Question #69

70-778 Question #69: Real Exam Question with Answer & Explanation

The correct answer is A. by MonthNumber. See the full explanation below for the reasoning.

Question

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?

Exhibits

70-778 question #69 exhibit 1
70-778 question #69 exhibit 2

Options

  • Aby MonthNumber
  • Bascending
  • Cdescending
  • Dby DateKey

Community Discussion

No community discussion yet for this question.

Full 70-778 Practice