cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
SarikaB
Regular Visitor

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")

SarikaB_0-1635266222473.png

 

Regards,

Sarika

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

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?

View solution in original post

1 REPLY 1
AlexisOlson
Super User
Super User

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?

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors