topic Average Time by Opportunity Stage in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-Time-by-Opportunity-Stage/m-p/3776247#M147595 <P>Hi Community,</P><P>&nbsp;</P><P>I have an opportunity history table, similar to the below, and I am trying to calculate the average length of time opportunities spend in each stage. I want to plot the average time, in days, on a time series with the categorical stages as my x-axis. I've created a separate table of the each opportunity stage and a corresponding order, so the stages plot in sequence on x-axis and will connect that reference table to my Opportunity['StageName'] table to accomplish this.</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>OpportunityId</TD><TD>StageName</TD><TD>Date</TD></TR><TR><TD>AA</TD><TD>Identification</TD><TD>1/1/23</TD></TR><TR><TD>AA</TD><TD>Qualification</TD><TD>2/1/23</TD></TR><TR><TD>AA</TD><TD>Cultivation</TD><TD>3/1/23</TD></TR><TR><TD>AA</TD><TD>Verbal Commitment</TD><TD><P>5/1/23</P></TD></TR><TR><TD>BB</TD><TD>Identification</TD><TD><P>2/1/23</P></TD></TR><TR><TD>BB</TD><TD>Qualification</TD><TD><P>3/1/23</P></TD></TR><TR><TD>BB</TD><TD>Verbal Commitment</TD><TD><P>7/1/23</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I don't necessarily care about time in each stage on an individual opportunityId level, rather, I want to show that, on average, opportunities spend 30 days in Identification and so on from there. Opportunities can skip stages, though.</P><P>&nbsp;</P><P>Any help in creating a DAX measure in support of this would be greatly appreciated. Thank you!&nbsp;</P> Tue, 19 Mar 2024 20:34:44 GMT samdep 2024-03-19T20:34:44Z Average Time by Opportunity Stage https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-Time-by-Opportunity-Stage/m-p/3776247#M147595 <P>Hi Community,</P><P>&nbsp;</P><P>I have an opportunity history table, similar to the below, and I am trying to calculate the average length of time opportunities spend in each stage. I want to plot the average time, in days, on a time series with the categorical stages as my x-axis. I've created a separate table of the each opportunity stage and a corresponding order, so the stages plot in sequence on x-axis and will connect that reference table to my Opportunity['StageName'] table to accomplish this.</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>OpportunityId</TD><TD>StageName</TD><TD>Date</TD></TR><TR><TD>AA</TD><TD>Identification</TD><TD>1/1/23</TD></TR><TR><TD>AA</TD><TD>Qualification</TD><TD>2/1/23</TD></TR><TR><TD>AA</TD><TD>Cultivation</TD><TD>3/1/23</TD></TR><TR><TD>AA</TD><TD>Verbal Commitment</TD><TD><P>5/1/23</P></TD></TR><TR><TD>BB</TD><TD>Identification</TD><TD><P>2/1/23</P></TD></TR><TR><TD>BB</TD><TD>Qualification</TD><TD><P>3/1/23</P></TD></TR><TR><TD>BB</TD><TD>Verbal Commitment</TD><TD><P>7/1/23</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I don't necessarily care about time in each stage on an individual opportunityId level, rather, I want to show that, on average, opportunities spend 30 days in Identification and so on from there. Opportunities can skip stages, though.</P><P>&nbsp;</P><P>Any help in creating a DAX measure in support of this would be greatly appreciated. Thank you!&nbsp;</P> Tue, 19 Mar 2024 20:34:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-Time-by-Opportunity-Stage/m-p/3776247#M147595 samdep 2024-03-19T20:34:44Z Re: Average Time by Opportunity Stage https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-Time-by-Opportunity-Stage/m-p/3776394#M147603 <P><img /></P> Tue, 19 Mar 2024 23:14:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-Time-by-Opportunity-Stage/m-p/3776394#M147603 ThxAlot 2024-03-19T23:14:33Z