Month Day Calendar table

[sraj]

Hi Everyone,

I created a new CALENDAR table for the below column:

Month Day = FORMAT([Date],"MMM dd") & " " & IF( FORMAT([Date],"dddd") = "Sunday", FORMAT([Date],"ddd" , "" ))

Sort z-A gives this 

Not sure how do I fix this, can someone please advise.

[sraj]

Ok, that worked..I think I understood it wrong but tried the sorting of the column with the new column you suggested and that worked.  Awesome!! Thank you very much!!

[VahidDM · Accepted solution]

HI @sraj 

Add another column with this code:
MonthDay NO. = FORMAT([Date],"MMdd")

then sort your Month Day column with MonthDay NO.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[sraj]

@VahidDM - Do you mind helping again? After I made that I saw that if I run it for the last 4 months that includes Dec 2021, this goes after the Jan 2022 & Feb 2022.  So I updated the Month day no with the year 

MonthDay NO. = FORMAT([Date],"MMddYYYY") and added year to the 

Month Day = FORMAT([Date],"MMM dd YYYY") & " " & IF( FORMAT([Date],"dddd") = "Sunday", FORMAT([Date],"ddd" , "" )) ...But this still didnt help, can you please advise on what I am missing here?

[VahidDM]

@sraj 

Can you share your PBIX file (after removing sensetive data)?

Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[sraj]

@VahidDM 

I do not have the option to attach a file here.