Forum Discussion
Average
I have the following three column are Date@Time, Time1 and Time2 in direct query. I created new column based on the Time1. The columns name is Hour.
I have two requirements:
1. I want to create time differece in-between Time2 and Time1 in time format. (HH:MM:SS)
2. I want to create average each line item based on the (point 1 result measure) time difference according to the date&time and Hour columns.
3. Grand Total of Time difference.
4. Grand Total of Measure.
Can you please suggest the solution for direct query menthod becuase those three columns are in DQ
Desired result look like.
PBI file attached
https://www.dropbox.com/s/tfcipx08wh6h7sc/Average-Measure.pbix?dl=0
6 Replies
Greg_Deckler ,
Thanks for your reply. Can you please help me becuase I am struggling to get the difference in-between two times. (Time2-Time1)
The article is explained single time column but I want to get the time difference from Time2 and Time and how can I get the average.
Can you please help me.Saxon202202 Right, so you need to convert both of the times to seconds. You can then take the difference in seconds between the two and then convert back to duration format. If you post your data as text that I can copy I can be more specific and give you a full solution.
