Forum Discussion

bbrauer100's avatar
bbrauer100
New Member
10 years ago

Time to Duration conversion throws an error.

I'm trying to convert time of day to duration in order to perform summary calculations.  However, when I try to convert time to duration in Query Editor the following error occurs:     DataFormat....
Anonymous's avatar
Anonymous
Not applicable
10 years ago

wonga

Even though I am not currently looking for a Gantt the new modelling works.

 

At the moment, I am trying to learn how to get sums of duration for specific tags. As per image below.

 

An error ensues when trying to edit the queries so I cannot see the steps taken. Tried to copy/paste the data into an excel and replace the source but it breaks as well. Would it be possible to ask for the excel you used? (BTW, how can one include an attachment?)

 

So, it seems that I may need to have different calculated columns to suffice different reporting needs. I may need a single column where it converts all into minutes and another one was Text for splitting time into mins, hours, days.

 

Thank you very much for your help

 

 

wonga's avatar
wonga
Continued Contributor
10 years ago

Hey Anonymous,

 

See if you can access this Google Drive documents: https://drive.google.com/open?id=0B-bZzUsHzLUnZ3ZUY05PQ1gwVmM

 

I made an edit to the queries, made a mistake where it's not getting the total minutes or hours and only extracting the minutes or hours part of the overall duration. Look at page 2 of the PBIX file and see if it's what you are looking for. 

 

Thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hello wonga

     

    I apologise for the late reply.

     

    The file you sent me seems to be it.

     

    Thank you very much for yout time and help.

     

    Kind regards,

    Joaquim