Forum Discussion

ompraashkumawat's avatar
ompraashkumawat
Frequent Visitor
3 years ago
Solved

Date Fomat

I want custom column formula for changing date format 7/28/2023 9:10:02 AM to 2023-7-28 9:10:02 in poewrbi Desktop. How can  I achieve this and the data is in Direct Query Mode.

Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi ompraashkumawat ,

     

    As far as I know, calculated column by FORMAT function will return a column in text data type instead of date data type.

    I suggest you to add a custom format in model view.

    Select the column and change the format as below.

    yyyy-mm-dd hh:mm:ss AM/PM

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

7 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    plse try this

    Column = FORMAT([Column1],"yyyy-mm-dd hh:mm:ss")

  • Dhairya's avatar
    Dhairya
    Solution Supplier
    3 years ago
    Hey ompraashkumawat 
    Please try the below formula to create a calculated column
    CalculatedColumn = FORMAT(YourTable[YourDateColumn], "yyyy-mm-dd hh:nn:ss AM/PM")

    If this helps you then please mark my solution as accepted so that others can find it quickly on facing similar issues. Thank You!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi ompraashkumawat ,

     

    As far as I know, calculated column by FORMAT function will return a column in text data type instead of date data type.

    I suggest you to add a custom format in model view.

    Select the column and change the format as below.

    yyyy-mm-dd hh:mm:ss AM/PM

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.