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....
wonga's avatar
wonga
Continued Contributor
10 years ago

Anonymous I've made a PBIX file but I can't get it to you yet. I need to find a way to upload it, thanks.

 

EDIT: I was able to upload it to the Power BI Community: http://community.powerbi.com/oxcrx34285/attachments/oxcrx34285/DesignMakeover052016/5/2/sample_ds.pbix

 

I had to reformat some of the start date and time data in an excel file, but you should be able to figure out how I got the calculated columns. Let me know if this is what you were looking for or at least if I was on the right track, thanks.

 

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