User Profile

lax

New Member

Joined 7 years ago

2 Posts

View All Badges

User Widgets

Contributions

Re: Date Display Formats
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
7 years ago Place Power Query
133KViews
0likes
1Comment
Re: Date Display Formats
Another option will be to use below formula Create a custom column as below formattedDate= RAW[OrderDate].[Year] &"-"& RAW[OrderDate].[MonthNo] &"-" & RAW[OrderDate].[Day] Make sure you convert the source column to date-time data type
7 years ago Place Power Query
133KViews
0likes
0Comments

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.