Solved: Total amount per day

Anonymous · ‎04-16-2019

I have a table that contains the columns;

Date

TimeItTookToCreateThePart

My form currently is counting the amount of entries per day. Is it possible to add all the time up for each day, so i have a total time for the parts.

I then intend to divide these numbers into the "Day working mins" value so i can get the percent that the machine is being used during working hours.

Thanks in advance.

v-chuncz-msft · ‎04-22-2019

@Anonymous ,

You may try the custom column below.

Time.Hour([Column1])*60 + Time.Minute([Column1]) + Time.Second([Column1])/60

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

parry2k · ‎04-16-2019

@Anonymous Add another column for minutes and then use that in the visual

TimeInMinutes = MINUTE( Table[TimeItTookToCreateThePart)

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎04-16-2019

Hi Parry,

The option you have suggested only takes the minutes out of the data.

eg If the data was 01:01:30 it would only be viewed as 1 Minute

Is it possible to convert data eg hh:mm:ss 01:01:30 into 61.5 minutes ?

Regards

parry2k · ‎04-16-2019

@Anonymous may be it is easier to add new column in power query using duration formula, add new custom column in power query and use following

https://docs.microsoft.com/en-us/powerquery-m/duration-totalminutes

Duration.TotalMinutes([<Your column name>])

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎04-17-2019

Perry, I am unable to convert to Duration (See attached image)

Any other suggestions?

I appreciate the help so far.

Regards,

v-chuncz-msft · ‎04-22-2019

@Anonymous ,

You may try the custom column below.

Time.Hour([Column1])*60 + Time.Minute([Column1]) + Time.Second([Column1])/60

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.