cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
PraveenRaj Regular Visitor
Regular Visitor

Change time format in edit queries

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 MMSmiley Very HappyD:YY HH:MM Please help me to acheive it.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
ryan_mayu Established Member
Established Member

Re: Change time format in edit queries

@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")

Capture.JPG

2 REPLIES 2
ryan_mayu Established Member
Established Member

Re: Change time format in edit queries

@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")

Capture.JPG

PraveenRaj Regular Visitor
Regular Visitor

Re: Change time format in edit queries

Thanks a lot for your help sir