Forum Discussion
Add integer (minutes) to datetime
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
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
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
It does work but i cant use it with direct query.
i need a directquery solution
hi ThiagoDuarte , you did not mention direct query in your question...but you can you use Number.Mod(5, 3) = (2 as an example.) Divide the integers by 60, then the modulus by 60 until less than 60 etc.
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.
NathanielHi ThiagoDuarte ,
What if you did this with DAX not in PowerQuery?
Nathaniel
