Forum Discussion
Responsive ResidentMonth Day Calendar table
Sort z-A gives this
Not sure how do I fix this, can someone please advise.
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/
5 Replies
srajOk, 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
Super User
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 theMonth 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
Can you share your PBIX file (after removing sensetive data)?
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/