Forum Discussion

ohohbudi's avatar
ohohbudi
Frequent Visitor
9 years ago
Solved

Cut Datetime Value

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. 

Show and Tell
Tutorial Requests
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    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

1 Reply

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    9 years ago

    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