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

KRISHP1234's avatar
KRISHP1234
Helper I
2 years ago

you can do by using format function like : date = format(date[date],"ddmmyy"), you can modifies "ddmmyy" to get different date formats