Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
1 year 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
    1 year 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
1 year ago

BeaBF It worked.
But when I tried to do sorty by column by Start of week.

I got this error message

I think it has something to do with no year being in new column that I created.
I think some sorting column needs to be created.

BeaBF's avatar
BeaBF
Icon for Super User rankSuper User
1 year ago

Justas4478 you can just order the column in the power query, so it will mantain that order, code:

= Table.Sort(Custom1, {{"Start of Week", Order.Ascending}})

 

 

or you can create an index in DAX like:

UniqueIndex =
RANKX(
    VALUES('Table'[Formatted Start of Week]),
    'Table'[Formatted Start of Week],
    ,
    ASC,
    Dense
)
and use this column to sort the new one.
 
BBF
  • Justas4478's avatar
    Justas4478
    Icon for Post Prodigy rankPost Prodigy
    1 year 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
      1 year 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