Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @Anonymous,
Just add a column to your data with the following syntax:
Date_Time_Format = FORMAT('Date'[DataTime],"DDD DD hh:mm")
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsYou 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.
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
Hi @Anonymous,
Just add a column to your data with the following syntax:
Date_Time_Format = FORMAT('Date'[DataTime],"DDD DD hh:mm")
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank 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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |