Forum Discussion
Time Diff between Times
Hi,
Please advice, thanks in advance
I have 5 columns TrainStartTime, TrainName, Date, and TrainFishTime I want to calculate the exact time the journey takes Duration
1.I would like to calculate the exact duration including the minute's train takes (HH: MM) TrainFishTime-TrainStartTime
2. Total Duration of all the train journey by month(date column)TrainFishTime-TrainStartTime Group by Date/Month
3Total Duration of all the train journey by TrainName( TrainName column)TrainFishTime-TrainStartTime Group by TrainName
Time format HH:MM:SS
The expected results for the requirement is below on the Duration column
| TrainStartTime | TrainFishTime | Duration | TrainName | Date |
| 02:20:00 | 02:50:00 | 00:30:00 | TrainA |01/7/2020 |
| 12:30:00 | 01:30:00 | 01:00:00 |TrainB |09/2/2020 |
2 Replies
You can have column like
[TrainFishTime]-[TrainStartTime ]
for aggregation refer
Hi MYDATASTORY ,
With your expected output,it seems easy to get the result by creating a column:TrainFishTime-TrainStartTime, but if you cant simply get the result by the expression,could you pls upload your .pbix file to onedrive business and share the link with us?Remember to remove the confidential informantion.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
