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

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?