Forum Discussion
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.
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 !!!
Greg_Deckler
Community Champion
Community ChampionAnonymous - There are custom date formats in the FORMAT function,
https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function
Also, you can do custom formatting using Custom Format Strings:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
This is how Chelsie Eiden's Duration works: https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389