Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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
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
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
User | Count |
---|---|
123 | |
96 | |
89 | |
73 | |
63 |
User | Count |
---|---|
138 | |
115 | |
111 | |
98 | |
95 |