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 !!!