https://community.fabric.microsoft.com/t5/Developer/Calculate-average-time-from-latest-date-average/m-p/1461036#M26271 <P>I want to calculate the average time from the latest date of the table. My table looks like this.</P><P>&nbsp;</P><P>datetime&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;time</P><P>01/01/2008 03:23:45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/01/2008&nbsp; &nbsp; &nbsp; &nbsp; 00:03:56</P><P>01/01/2008 04:20:45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/01/2008&nbsp; &nbsp; &nbsp; &nbsp; 00:02:15</P><P>01/01/2008 01:23:45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/01/2008&nbsp; &nbsp; &nbsp; &nbsp; 00:01:56</P><P>01/01/2007 03:23:45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/01/2007&nbsp; &nbsp; &nbsp; &nbsp; 00:03:56</P><P>01/01/2007 03:23:45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/01/2007&nbsp; &nbsp; &nbsp; &nbsp; 00:03:56</P><P>01/01/2007 03:23:45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/01/2007&nbsp; &nbsp; &nbsp; &nbsp; 00:03:56</P><P>&nbsp;</P><P>I want to display as average time for 01/01/2008 by calculating the average time taken from 3 valuses from time column.</P><P>&nbsp;</P><P>Avg Time : 00:02:13 (from latest date)</P><P>&nbsp;</P><P>any help is appreciated. thanks</P> Wed, 28 Oct 2020 13:26:11 GMT novice1 2020-10-28T13:26:11Z https://community.fabric.microsoft.com/t5/Developer/Calculate-average-time-from-latest-date-average/m-p/1461036#M26271 <P>I want to calculate the average time from the latest date of the table. My table looks like this.</P><P>&nbsp;</P><P>datetime&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;time</P><P>01/01/2008 03:23:45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/01/2008&nbsp; &nbsp; &nbsp; &nbsp; 00:03:56</P><P>01/01/2008 04:20:45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/01/2008&nbsp; &nbsp; &nbsp; &nbsp; 00:02:15</P><P>01/01/2008 01:23:45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/01/2008&nbsp; &nbsp; &nbsp; &nbsp; 00:01:56</P><P>01/01/2007 03:23:45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/01/2007&nbsp; &nbsp; &nbsp; &nbsp; 00:03:56</P><P>01/01/2007 03:23:45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/01/2007&nbsp; &nbsp; &nbsp; &nbsp; 00:03:56</P><P>01/01/2007 03:23:45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/01/2007&nbsp; &nbsp; &nbsp; &nbsp; 00:03:56</P><P>&nbsp;</P><P>I want to display as average time for 01/01/2008 by calculating the average time taken from 3 valuses from time column.</P><P>&nbsp;</P><P>Avg Time : 00:02:13 (from latest date)</P><P>&nbsp;</P><P>any help is appreciated. thanks</P> Wed, 28 Oct 2020 13:26:11 GMT https://community.fabric.microsoft.com/t5/Developer/Calculate-average-time-from-latest-date-average/m-p/1461036#M26271 novice1 2020-10-28T13:26:11Z