Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Date format to show day of the week

I want to create a date column that shows date format in this form ddd /mm/dd/yyyyy hh :mm basically should show day of the week ,  month, date, year and time

1 REPLY 1
tackytechtom
Super User
Super User

Hi @Anonymous ,

 

I see two options.

 

Either in Power Query, by using the Date.ToText formular (check out this one here)

 

Or you try the FORMAT function in DAX.

 

Either way your date will be translated to text which means that you cannot really use that attribute to apply Power BIs strong date manipulation capabilities. So, my suggestion is to have the normal date column and in addition a column with the date format you like. With that you can do use the real one for date calculations annd the other one to show in your graph.

 

Let me know if this helps 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

 

 



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors