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 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