Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

changing data type

Hello,   Im new to Power BI and im kinda stuck while changing data type from text to duration. When I change the data type it gives me this error: "expression.error can not parse the literal durati...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous

    You may try this way:

    Select t_time column, duplicate the column, then split the duplicate column

    Then filter column t_time - Copy.1 who is greater than 2

     

    Best Regards,

    Lin

     

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Something like this?

I have selected the time value which is causing the problem.

 

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, Anonymous

     

    Power bi not support duration type, I'd like to suggest you convert it as total second or other similar numeric value to calculate.
    You can also take a look at below blog to know how to handle with duration in power bi:

    Aggregating Duration/Time

    What is your expected output in power bi(not power query )? maybe we could help you get your expected output by DAX.

     

    Best Regards,

    Lin

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I want to filter the tickets in Power BI who have a time of 2 hours +

      • v-lili6-msft's avatar
        v-lili6-msft
        Community Support
        7 years ago

        hi, Anonymous

        You may try this way:

        Select t_time column, duplicate the column, then split the duplicate column

        Then filter column t_time - Copy.1 who is greater than 2

         

        Best Regards,

        Lin