Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Varchar column to milliseconds

Hello everyone,   I have 3 columns (nvarchar(50)) in a SQL table, that represent the multiple durations that occur in a call. As an example   duration_1 duration_2 duration_3 00.00:04:53....
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    I'm not sure what your raw data looks like (in SQL), powerBI allows you to change the display format,


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous ;

I'm not sure what your raw data looks like (in SQL), powerBI allows you to change the display format,


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    After formatting, if I do the calculations between them it preserves the milliseconds, which it was what I was looking for 🙂