Forum Discussion
Unable to subtract two columns in the power query
I was trying to subtract two columns with date/time, time datatype on the power query but I selected the desired columns the Date , Time options on the Add Columns Section gets disabled . I don't know what is happening here if anyone can help please
I am on the september version
In such situation, there are several useuful function.
If you want to calculate the difference of just houre or minute part if two Date.Time use
Duration.Minutes
Duration.Hours
Duration,Second
But if you want to calculate total differnce in hours or minute use
Duration.TotalHours
Duration.TotalMinutes
5 Replies
The result of datetime minus datetime is a duration type value. That's why you no longer see the datetime tools. If you want the result to be 12:47:05 AM, then you need to use Duration.TotalDays (not Duration.Days) and then Time.From. So
= Table.AddColumn(PriorStepOrTableName, "Time", each Time.From(Duration.TotalDays[Subtraction])))
--Nate
- Omid_Motamedise
Super User
In such situation, there are several useuful function.
If you want to calculate the difference of just houre or minute part if two Date.Time use
Duration.Minutes
Duration.Hours
Duration,Second
But if you want to calculate total differnce in hours or minute use
Duration.TotalHours
Duration.TotalMinutes - Omid_Motamedise
Use
Duration.Days
- Omid_Motamedise
If this answer helped resolve your issue, please consider marking it as the accepted answer. And if you found my response helpful, I'd appreciate it if you could give me kudos. Thank you!
https://drive.google.com/file/d/10voipz3SMxxKmPu5CMRXYRUVpL2IJsb4/view?usp=drivesdkvideo I don't understand what your are saying but if go to the advanced editor and write the code I am trying to do ,it works
