Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Transforming Jira Data in Power BI

    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 hour...
Need Help
  • ibarrau's avatar
    ibarrau
    6 years ago

    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,

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
6 years ago

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,