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

     

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Are you trying to do this in DAX or Power Query?

 

Can you post an example of the data? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

That being said, check out these links:

https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486

https://community.powerbi.com/t5/Quick-Measures-Gallery/Milliseconds-Duration/m-p/406698

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I am trying to do this in power query, the thing is that currently, the data type for the duration is text. But I want to make a schema with a filter which shows just certain durations. 

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

    hi, Anonymous

    Please share your sampe pbix or some data sample and the formula and expected output.

    It will be helpful for us to solve this case.

     

    Best Regards,

    Lin

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      It happens when I change the data type from text to duration and it only gives an error where the duration is greater than 24 hours. How is it possible to fix that issue?