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
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.
Nathaniel
- Nathaniel_C4 years agoCommunity Champion
Hi ThiagoDuarte ,
What if you did this with DAX not in PowerQuery?
Nathaniel- ThiagoDuarte4 years agoHelper I
That was my first tought.
I tried doing this on dax but i couldn't get it to work properly
var tap = reportfusion[Tap to Tap] (this is a measure. it sums a few columns) //inicial var iniciohora = HOUR(MAX(reportfusion[start date])) var iniciominuto = MINUTE(MAX(reportfusion[start date])) var iniciodia = INT(MAX(reportfusion[start date])) var iniciosegundo = SECOND(MAX(reportfusion[start date])) //duração var duracaohora = INT(divide(tap,60)) var duracaominuto = int(reportfusion[Tap to Tap]) var duracaodia = INT(DIVIDE(tap,1440)) //final var finaldia = convert(iniciodia+duracaodia,DATETIME) var finalhora = mod(iniciohora+duracaohora,24)+int(divide(duracaominuto,60)) var finalminuto = mod(iniciominuto+duracaominuto,60) //data final var dia = DATE(YEAR(finaldia),MONTH(finaldia),day(finaldia)) var hora = IF(LEN(finalhora)=1,0&finalhora,finalhora) var minuto = IF(LEN(finalminuto)=1,0&finalminuto,finalminuto) var datafinal = dia&" "&hora&":"&minuto&":"&iniciosegundo return datafinal- Nathaniel_C4 years agoCommunity Champion
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