You are creating a report in Power BI Desktop.

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

References: http://ppmworks.com/sorting-month-names-chronologically-in-microsoft-power-bi-reports/