Forum Discussion
Average
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.
Greg_Deckler ,
Thanks for your reply. Now, I convert the both times to seconds and finout the time difference in seconds. I try to convert the time difference measure into duration but result is 00:00:00.Attached the csv and PBI file.
https://www.dropbox.com/s/tfcipx08wh6h7sc/Average-Measure.pbix?dl=0
https://www.dropbox.com/s/mf04tzid2wub1ay/Time%20conversation.csv?dl=0Hi,
Try these 2 calculated column formulas
Column = if('Table'[Time2]=BLANK(),BLANK(),'Table'[Time2]-'Table'[Time1])Column 2 = CALCULATE(AVERAGE('Table'[Column]),FILTER('Table','Table'[Hour]=EARLIER('Table'[Hour])))Hope this helps.
Ashish_Mathur, Thanks for your reply. I am looking for measures instead of calculated column because calculated column not supporting in direct query.
Thank you.
