Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Changing date format to have short month name

Hi, I have this start of week column in my calendar I want to create another column that would show start of week from this format in the image to this "14 Oct" I know there is option to chang...
Need Help
  • BeaBF's avatar
    BeaBF
    2 years ago

    Justas4478 Hi! Try with:

    = Table.TransformColumns(#PREVIOUS STEP, {{"Start of Week", each Date.ToText(_, "dd MMM"), type text}})

     

     

     

    If it's ok, please accept my answer as solution!

     

    BBF

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
2 years ago

BeaBF I created another column that has year in it and it allows sorting without any problems.

 

BeaBF's avatar
BeaBF
Icon for Super User rankSuper User
2 years ago

Justas4478 Of course, it happened because there were multiple years for the same date. But I thought you wanted it intentionally without the year. So it works. Accept my first response as the solution

 

BBF