Changing date format to have short month name

[Justas4478]

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 change date formating in column

But the problem with this is that it gives month name in full where I want only short versions that only show first 3 caracter of the month like this 

I tried to use this mcode solution to solve my problem but it did not work.
Date.ToText(#date([#"Start of Week"]),[Format="dd-mmm", Culture="en-UK"])
And it gave me this error instead

I am not really good with mcode so I am not sure on how to do it.

[Omid_Motamedise]

Add a new column by rewriteing the formula as follow

Date.ToText([#"Start of Week"]),[Format="dd-mmm", Culture="en-UK"])

[BeaBF · Accepted solution]

@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]

@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]

@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]

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

[BeaBF]

@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