Date Fomat

[ompraashkumawat]

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.

[v-rzhou-msft · Accepted solution]

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.

[Dhairya]

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!

[Ahmedx]

probably yes!

[Ahmedx]

plse try this

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

[ompraashkumawat]

I am getting this error. Is it due to Direct Query Mode?

[ompraashkumawat]

I am getting this error. Is it due to Direct Query Mode?

[mlsx4]

Hi @ompraashkumawat 

Can you change it in Model View?