Time calculation to predict end time

[Pricef1]

Could not find a solution that was similar to what I need. I am not sure how to calculate the end time for a particular item. Basically we have a start time (ex. 08:15am) with a 7.5hr cycle, to be removed at (15:15PM). How can I use Power BI to calculate: Time In x Cycle Time = Removal Time?

[HamedM1125]

Hi @Pricef1 ,

You can do this in M query but before that you need to have Date and Time columns combined.

After combining it, create a custom column in M query as:
= [Date] + #duration(0,0,0,27000) 
--here 27000 is in seconds (7.5 hours)

Result:

Thanks,

Hamed

https://www.linkedin.com/in/hamed-mohammed-6aa073197/

[Pricef1]

Or would i need to somehow convert cycle time in a seperate column and then refence that column?

[Pricef1]

Is there a way to have it update automatically? For example not all cycle times are the same. Could vary from 6hrs to 7.5hrs depending on product. Time in * Cycle Time / ?????? maybe?

[HamedM1125 · Accepted solution]

I hope this works, I just divided Cycle Time by 24 (here 24 is hours in a day)

[Pricef1]

Modified just slightly and it gave me the exact times I was looking for!! Thank you for your help

[HamedM1125]

Awesome! Please mark my reply as a solution 🙂 

[sevenhills]

Tune to your needs:

DAX way

Removal Time = 'Table'[Time In] + Time(7, 30, 0)

M Query way

= Table.AddColumn(#"Changed Type", "Removal Time", each [Time In] + #duration(0, 7, 30, 0), type time)

Hope this helps

[VijayP]

@Pricef1 

Question is not clear!