https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-between-multiple-dates/m-p/372706#M156520 <P>Hi,</P><P>&nbsp;</P><P>So I have the following table:</P><P><img /></P><P>&nbsp;</P><P>And I want to calculate the average date difference, so that the result would look like this:</P><P>Identificação&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Nascimento 1&nbsp; &nbsp; &nbsp; Nascimento 2&nbsp; &nbsp; &nbsp;(....)&nbsp; &nbsp;Average Date Diference (Months)</P><P>PT 04077 1281&nbsp; &nbsp; &nbsp; 5/7/2017&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20/6/2016&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12</P><P>PT 31760 3837&nbsp; &nbsp; &nbsp; 1/12/2017&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;null&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;null</P><P>&nbsp;</P><P>I manage to get very close with some attemps, but never quite like this.</P><P>&nbsp;</P><P>I also want that the average only consider the "Nascimento" that have values.</P><P>&nbsp;</P><P>Some "Identificação" have multiple "Nascimento", and thats the hard part, because the number of "Nascimento" varies, with different "Identificação".</P><P>&nbsp;</P><P>Hope that someone can help.</P> Thu, 08 Mar 2018 23:24:12 GMT PompeuPD 2018-03-08T23:24:12Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-between-multiple-dates/m-p/372706#M156520 <P>Hi,</P><P>&nbsp;</P><P>So I have the following table:</P><P><img /></P><P>&nbsp;</P><P>And I want to calculate the average date difference, so that the result would look like this:</P><P>Identificação&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Nascimento 1&nbsp; &nbsp; &nbsp; Nascimento 2&nbsp; &nbsp; &nbsp;(....)&nbsp; &nbsp;Average Date Diference (Months)</P><P>PT 04077 1281&nbsp; &nbsp; &nbsp; 5/7/2017&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20/6/2016&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12</P><P>PT 31760 3837&nbsp; &nbsp; &nbsp; 1/12/2017&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;null&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;null</P><P>&nbsp;</P><P>I manage to get very close with some attemps, but never quite like this.</P><P>&nbsp;</P><P>I also want that the average only consider the "Nascimento" that have values.</P><P>&nbsp;</P><P>Some "Identificação" have multiple "Nascimento", and thats the hard part, because the number of "Nascimento" varies, with different "Identificação".</P><P>&nbsp;</P><P>Hope that someone can help.</P> Thu, 08 Mar 2018 23:24:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-between-multiple-dates/m-p/372706#M156520 PompeuPD 2018-03-08T23:24:12Z