cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ichebobo Member
Member

Change date display format

 

Hi,

 

My Date is in format 01/09/2017 00:00:00 ie (DD/MM/YYYY hh:mm:ss) as below:

 

DataTime
01/09/2017 00:00:00
01/09/2017 00:30:00
01/09/2017 01:00:00
01/09/2017 01:30:00
01/09/2017 02:00:00
01/09/2017 02:30:00
 
 
 

 

 

but I want it to display like the below format:

 

Fri 01 02:30  ie (DDD DD hh:mm)

 

Expected Results:

DataTime
Fri 01 00:00
Fri 01 00:30
Fri 01 01:00
Fri 01 01:30
Fri 01 02:00
Fri 01 02:30

 

Please help

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Change date display format

Hi @ichebobo,

 

Just add a column to your data with the following syntax:

 

Date_Time_Format = FORMAT('Date'[DataTime],"DDD DD hh:mm")

Date_format.png

 

Regards,

MFelix

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




4 REPLIES 4
Super User
Super User

Re: Change date display format

Hi @ichebobo,

 

Just add a column to your data with the following syntax:

 

Date_Time_Format = FORMAT('Date'[DataTime],"DDD DD hh:mm")

Date_format.png

 

Regards,

MFelix

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Super User
Super User

Re: Change date display format

Hey,

 

you can use this little DAX statement to create a calculated column

Column with Display Value = FORMAT('Table2'[DatetoFormat],"DDD DD hh:mm")

Please be aware, that creating a new column will have impact on filtering the rows of the table or all the related tables.

 

It's not possible to change just the "display" format

 

Hopefully this gets you started

 

Regards

Tom 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
Super User
Super User

Re: Change date display format

You are going to have to create a new column that uses a combination of WEEKDAY, SWITCH, CONCATENATE and FORMAT functions.

 

Something like:

 

Column = var wday = WEEKDAY(Events[EventTime])
var wdayname = SWITCH(wday,1,"Sun ",2,"Mon ",3,"Tue ",4,"Wed ",5,"Thu ",6,"Fri ",7,"Sat ")
RETURN CONCATENATE(wdayname,FORMAT(Events[EventTime],"dd hh:mm"))

 

Update: The other solutions work as well although not documented here:

https://technet.microsoft.com/en-us/library/ee634398(v=sql.130).aspx

 

I would disagree that it is not possible to just change the display format, you can do that in the Modeling tab by having a data type of Date/Time and changing the Format via the dropdown. But, there is no choice for your particular format.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
ichebobo Member
Member

Re: Change date display format

Thank you all for your tremendous help.

Date_Time_Format = FORMAT('Date'[DataTime],"DDD DD hh:mm")…..This simply worked in this instance:

I truly appreciate all your contributions.