time of day + duration using calculated columns

[Anonymous]

Hi Forum. 

I'm new to PBI and looking for some help from the amazing community in this forum. I know the methods I've used will not be the best but here is where I am. 

table with 5 colunms as detailed below CC denotes calculated column:
Date: dynamically pulled from excel spreadsheet

Packs per day:  dynamically pulled from excel spreadsheet

packs per day / a measure (CC): This gives me a duration in decimal format. 

Duraction correct format (CC): I use ([FF daily total / past 5 measure]*0.041666666666666) to give me a duration formated in Date/time [h:nnn:ss]

Start Time: dynamically pulled from excel spreadsheet. fomratted in PBI as Time.

Please can a master of PBI help me create a calculated column where the duration is added to the start time to show a finish time. please note Data populated for future dates are forecasts. 

My desired result is to then use this column on a card to show the estimated finish time for the present day. 

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please try to create a calculate column with below dax formula:

Column = FORMAT('Table'[Start Time]+ TIMEVALUE([duration correct format]),"h:nn:ss AM/PM")

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please try to create a calculate column with below dax formula:

Column = FORMAT('Table'[Start Time]+ TIMEVALUE([duration correct format]),"h:nn:ss AM/PM")

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

@Anonymous thank you so much! I was so close I just didn't use the "timevalue" function. You've helped me out massively thank you!