How should you sort the MonthName column?

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 he 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

microsoft-exams

2 thoughts on “How should you sort the MonthName column?

    1. Hi Roelof, month number is in mm format which gives 1 to 12 digits for respective months. Hence easy to sort month name with month number

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.