Change time format in edit queries

[PraveenRaj]

I'm new to PowerBI, i'm getting time series data from sql, contains multiple tables. I have to create relation to each tables, only unique column is timestamp. But timestamp differs in milli seconds for each table. So i cannot able to create a relation ,i need to change the date time format to MM:DD:YY HH:MM Please help me to acheive it.

Thanks

[ryan_mayu · Accepted solution]

@PraveenRaj

You can create a column to transfer the date type. Hope this is helpful. Thanks.

Column = FORMAT(Sheet1[Column1],"DD/MM/YYYY HH:MM")

[PraveenRaj]

Thanks a lot for your help sir