Forum Discussion

Sow-1's avatar
Sow-1
New Member
1 year ago
Solved

Date formatting

Need help in formatting the date column in the below format ddd, dd MMM, yyyy (Fri, 22 Nov,2024).   Used the measure for column as below however it is converting the date into text. FORMAT(table...
Need Help
  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    1 year ago

    Hi Sow-1 ,

    Make sure your data type is set for Date, and in format field past the the follow string: ddd, dd MMM, yyyy

     

    Your final result will look like this:

     

     

Kedar_Pande's avatar
Kedar_Pande
Super User
1 year ago

Sow-1 

In Power BI, the FORMAT function converts a value into a text string. Since you need to keep the column as a "Date" data type, FORMAT alone won't suffice. Unfortunately, Power BI does not allow for custom date formats directly while retaining the data type as Date.

 

Go to the Power Query Editor.
Duplicate the Date column.
Format the new column using Power Query's built-in options (under "Transform" → "Format").
Use the original Date column for calculations, and the formatted text column for display.

 

💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn