Forum Discussion

SoulCuber's avatar
SoulCuber
Frequent Visitor
9 years ago
Solved

create own date format dd d-MMM-yy

I would like to display dates in charts including the weekday.   There is one standard option available which is: Wednesday 1 March 2001 (dddd d MMMM yyyy)   However for display purposes, I would...
  • Anonymous's avatar
    Anonymous
    9 years ago

    You can create a calculated column, and use the FORMAT( ) function to specify any format string you desire :)

  • hohlick's avatar
    hohlick
    9 years ago

    If in Power Query (Query Editor), you can use Date.ToText() function for the same goals.

    Just dont forget to set "sort by column" option later when modelling data

     

hohlick's avatar
hohlick
Icon for Continued Contributor rankContinued Contributor
9 years ago

If in Power Query (Query Editor), you can use Date.ToText() function for the same goals.

Just dont forget to set "sort by column" option later when modelling data