Date/Time + Decimal number [number of hours] to get result in Date/Time

[Anonymous]

Hello,

I need to calculate the Starting date and time + period (in hours) to get the result in date/time.

My data setting is following:

Starting Date [Date/Time dd:mm:yyyy hh:nn:ss	Period (Decimal number in hours)	End date (Starting date + period)
1.1.2020	97	??

I tried to conver the Period in Decimal numbers to Time format, but it doesn't work for higher values.

Thanks for help.

Petr

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

You can use the following measure:

End date =
VAR vday =
    INT ( MAX ( 'Table'[Period] ) / 24 )
VAR vSeconds =
    MOD ( MAX ( 'Table'[Period] ), 24 ) * 3600
VAR vMinutes =
    INT ( vSeconds / 60 )
VAR vRemainingSeconds =
    MOD ( vSeconds, 60 )
VAR vHours =
    INT ( vMinutes / 60 )
VAR vRemainingMinutes =
    MOD ( vMinutes, 60 )
RETURN
    MAX ( 'Table'[Starting Date] ) + vday
        + TIME ( vHours, vRemainingMinutes, vRemainingSeconds )

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[rogletree]

Try something like this:

End date = [Starting Date] + #duration(0, [Period], 0, 0)

https://community.powerbi.com/t5/Desktop/How-to-add-hours-to-DateTime-data/td-p/104443