Transforming Jira Data in Power BI

[Anonymous]

Hello I have integrated data from Jira into Power BI with a REST-API for Jira Data. Most of the transformations worked well. However, I always get error messages when I want to convert the hours worked on a ticket into a duration. Does somebody has any idea? As you can see in the picture this is the output i get. If i try to transform it, I allways get an error. Thank you

[ibarrau · Accepted solution]

Hi. That is strange. I'm using jira's api and you have some fields with just seconds values to work with without using that one. I don't think that format will convert to duration. You can try replacing some characters to build something like "hh:mm:00" in order to convert to duration like replace "h " with ":" and add "m " with ":00". If you just want to sum numbers in hours split by "h" and then use math to convert minutos to hours and sum them to the other values.

hope that helps,

Regards,