How should you sort the MonthName column?

You are create a report in Power BI Desktop.

You are consuming the following tables.

Date [Date] is in the mm/dd/yyy format. Date[DateKey] is in the ddmmyyy format. Date[MonthNumber] is in the mm formate[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 . descending
C . ascending
D . by DateKey

View Answer

Answer: B