Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Is there a way to create custom date formats?

I'm looking for a way to create a custom date format as DD/MMM/YYYY but right now Power BI only supports DD/MMM/YY.  
Need Help
  • Anand24's avatar
    Anand24
    6 years ago

    Hi Anonymous ,

     

    You can achieve the DD/MMM/YYYY format by creating a new column with below DAX:

    Date_Column = FORMAT(Tablename[date_field],"dd/mmm/yyyy")
     
    Refer below image:
     

    Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

Stives93's avatar
Stives93
Icon for Advocate I rankAdvocate I
3 years ago

You can now apply custom date formats within Model View, without having to convert to text in query editor or via a measure.

 

 

JPritch's avatar
JPritch
Icon for Advocate I rankAdvocate I
1 year ago

I've been spinning my wheels for an entire day and find this gem buried in the comments.  THANK YOU THANK YOU THANK YOU!