topic Re: Dax - Create weekday in chronological order in DAX Commands and Tips

Dax - Create weekday in chronological order

Anonymous — Mon, 07 Nov 2022 17:16:02 GMT

Hello World,

I have a column called PaymentDate.

I then created a new column called Weekday this way. Weekday = FORMAT(Final[PaymentDate ],"DDDD")

I created a visualization. But the weekday is not showing in chronological order. I sorted by weekdays but didn't work. How do I arrange in chronological order: Weekday starts from Sunday (US weekday). I want the visual weekday to be displayed as sun, mon, tues, wed, thurs, fri and sat.

Re: Dax - Create weekday in chronological order

Greg_Deckler — Mon, 07 Nov 2022 17:22:03 GMT

Anonymous Use the WEEKDAY function and set it as a Sort By column.

Re: Dax - Create weekday in chronological order

Anonymous — Mon, 07 Nov 2022 17:40:11 GMT

Greg_Deckler It's giving me Saturday as 1 . I want the weekday to start from sunday. How to fix it?

Re: Dax - Create weekday in chronological order

Anonymous — Mon, 07 Nov 2022 17:53:26 GMT

I fixed it. Thank you