Forum Discussion
Calculating Stage Duration
Awesome! Give this a shot
Create MeasureRankx = RANKX( FILTER(ALL(Tabel), Tabel[OpportunityID] = MAX(Tabel[OpportunityID])), CALCULATE( max(Tabel[CreatedDate]) ) ,,ASC )And then this second measure
My mistake. i read it as average stage.
(0+58+52+0+1+18+2+10+22+108+58+71) / Number og stages (12) = 31.5
Try this in stead
I have added some sample data.
Awesome! Give this a shot
Create Measure
Rankx =
RANKX(
FILTER(ALL(Tabel), Tabel[OpportunityID] = MAX(Tabel[OpportunityID])),
CALCULATE(
max(Tabel[CreatedDate])
)
,,ASC
)And then this second measure
Thank you so much. Saves the day. NickolajJessen
But I am stuck in another approach. Basically, I need to calculate the average duration of each stage. That is (the count of days/Number of opportunities) in each stage.
I can not use the stageDays in the new calculated measure as it's a secondary variable.
Note that this also counts the last stage comparing the starting dato to TODAY.
I think there is a mistake. If I do that It gives an output like this picture (filtered on Stage 1 Closed Won).
Here, there are 5 opportunities in Closed Won, and the total days for all the 5 opportunities in stage Closed Won is 400. So the average would be 400/5 = 80.
I was thinking about this.