Forum Discussion
Justas4478
Post Prodigy
Post ProdigyChanging 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...
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
Omid_Motamedise
Super User
Super UserAdd a new column by rewriteing the formula as follow
Date.ToText([#"Start of Week"]),[Format="dd-mmm", Culture="en-UK"])