Forum Discussion
Add integer (minutes) to datetime
- 4 years ago
New Time1 = MAX('Table'[Time]) + MAX('Table'[Integers])/24/60Hi ThiagoDuarte Try this.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
New column = [Start Date] + time(0,[Duration(Minute]), 0)
it doesn't work
the column duration minutes have values over 3000
- Nathaniel_C4 years agoCommunity Champion
Hi ThiagoDuarte Try
[Time]+#duration(0,0,[Integers],0)
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel- Nathaniel_C4 years agoCommunity Champion
Hi ThiagoDuarte
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel- ThiagoDuarte4 years agoHelper I
It does work but i cant use it with direct query.
i need a directquery solution