Forum Discussion

SarikaB's avatar
SarikaB
Regular Visitor
4 years ago
Solved

Sort End of Week

Hello Team,

 

I have created a End of week column in the CALENDAR table, however unable to sort it chronologically, How can I fix this?

Here is my end of week formula

cEOW = FORMAT([Date] + 4 - WEEKDAY([Date],2),"dd-mmm-yyyy")

 

Regards,

Sarika

DAX
sorting
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    FORMAT returns a text value but you probably want a date. What if you remove the FORMAT wrapper and make sure it's a date type column and format the display via the column tools?

1 Reply

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    4 years ago

    FORMAT returns a text value but you probably want a date. What if you remove the FORMAT wrapper and make sure it's a date type column and format the display via the column tools?