Forum Discussion

hodeuria's avatar
hodeuria
Frequent Visitor
3 years ago

String duration into Time Duration

Hi,

 

I am trying to convert the string duration into time duration but I am having issues with the DAX coding. 

 

The time string is formatted such as: hh:mm:ss

 

I hope some of you can help me with this. 

 

Thank you! 

Need Help
Tips and Tricks

2 Replies

  • ChristianDGreat's avatar
    ChristianDGreat
    Resolver I
    3 years ago

    Have you tried to convert those from a String/Text to Time in Power Query?
    That is when you click "Transform Data" in Power BI Desktop.

     

    Thanks

    Chris

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    3 years ago

    what are you struggling with exactly.

     

    1. providde some sample data in text format

    2. provide expected result

    3. if you have what you have done, share so that we can correct the issue?