My Date is in format 01/09/2017 00:00:00 ie (DD/MM/YYYY hh:mm:ss) as below:
but I want it to display like the below format:
Fri 01 02:30 ie (DDD DD hh:mm)
|Fri 01 00:00|
|Fri 01 00:30|
|Fri 01 01:00|
|Fri 01 01:30|
|Fri 01 02:00|
|Fri 01 02:30|
Solved! Go to Solution.
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
You are going to have to create a new column that uses a combination of WEEKDAY, SWITCH, CONCATENATE and FORMAT functions.
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:
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.
Proud to be a Datanaut!