Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I can't turn data type to duration

Hello everyone,   I'm currently trying to turn a string column to duration type using Power Query :     But it results as an error :     Why do you think that happens? Do you thin...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello,

    Thanks for the tip, it kinda worked, but not perfectly :

     

    The format is all right, but it's now counting what are supposed to be hours as minutes.
    I guess it's because of something in the DAX code. I'm not very found of this code, so does an easy fix exists ? Or maybe resources to learn more about the DAX.

    Thank you by advance.

    • KBO's avatar
      KBO
      Icon for Memorable Member rankMemorable Member
      4 years ago

      Hi Anonymous ,

      this is not DAX its M-Script in Power Query :). If you are looking to learn more about Power Query, there are a lot of great Blogs and Youtube Videos out there :).

      If you have a Demo file for me I can check your code and formatting 🙂

      Best,

      Kathrin

       

       

       

       

      If this post has helped you, please give it a thumbs up!
      Did I answer your question? Mark my post as a solution!