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
Why not datekey?
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