Forum Discussion
Solved
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 kno...
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
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