topic Re: Dax- Day and month in Chronological order in DAX Commands and Tips

Dax- Day and month in Chronological order

Anonymous — Wed, 07 Dec 2022 18:35:15 GMT

Hello World,

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

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

Re: Dax- Day and month in Chronological order

Greg_Deckler — Wed, 07 Dec 2022 19:12:58 GMT

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.

Re: Dax- Day and month in Chronological order

Anonymous — Wed, 07 Dec 2022 20:30:02 GMT

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

Re: Dax- Day and month in Chronological order

ppm1 — Thu, 08 Dec 2022 01:31:00 GMT

Please see this article.

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

Pat

Re: Dax- Day and month in Chronological order

Anonymous — Thu, 08 Dec 2022 15:59:27 GMT

ppm1 Greg_Deckler Thank you. It worked.