Cut Datetime Value

[ohohbudi]

Hi guys, i want to ask, i have datetime value with value i.e "2013-11-24 00:00:00.000". How to cut datetime value in Power BI so i only could get "2013-11-24" or only date value without time?

Thank you all. 

[v-caliao-msft · Accepted solution]

Hi @ohohbudi,

If you need a string column, you create a calculated column by using DAX below.
Column = FORMAT(Sheet7[DateTime],"YYYY-MM-DD")

OR you can change the format to yyyy-MM-dd

 

Regards,

Charlie Liao