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

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks this works but what if a new value is added in the t_time column, will it be automatically split in the other columns wich I made?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    okay, :smileyhappy: one last question. What if I publish it and make a dashboard with those details. Will the new data that is added automatically be synced and divided into these columns? 

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

    hi, Anonymous

    Yes, the new data that is added automatically will be synced and divided into these columns.

    Of course, you need to learn about how to set refresh.:smileyhappy:

     

    Best Regards,

    Lin

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    okay thank you very much for your help