Dax- Day and month in Chronological order

[Anonymous]

Hello World,

How do I sort the weekday and month in chronological order? 

I did sort by month but still doesn't work. 

[Anonymous]

@ppm1 @Greg_Deckler Thank you. It worked. 

[Greg_Deckler]

@Anonymous You need numeric Sort By columns. You create those using MONTH and WEEKDAY and then set your text columns to have a Sort By column of the corresponding numeric columns. This is done in the Column Tools tab of the ribbon.

[Anonymous]

@Greg_Deckler Sorry, I didn't get what you are saying. 

[ppm1 · Accepted solution]

Please see this article.

Sort one column by another column in Power BI - Power BI | Microsoft Learn

Pat