Forum Discussion
Solved
Date Display Formats
Using Power BI Desktop to create reports and charts. What is the syntax for displaying dates in specific formats. For example, "01/25/2015" instead of "Monday, January 25, 2015". Etc. Thanks!
click on the time field in your model then you can click on Modeling in the Desktop ribbon and pick the desired date format
Another option which I discovered while trying to deal with this issue is using the below DAX function
Create a new Custom Column (formattedDate below)
formattedDate = RAW[OrderDate].[Year] &"-"& RAW[OrderDate].[MonthNo] &"-" & RAW[OrderDate].[Day]
Where OrderDate is your original column
Make sure you convert OrderDate to DateTime Column.
PS: I realize, I'm replying to an old post but hoping it help others
Cannot be used with the variation 'Year' because it does not have any...
Its a Date/Time field...