Forum Discussion
Solved
Calculating Stage Duration
I want to calculate how long the opportunities are staying in each stage. I have this. Now I want the following output. Here my condition is- for example - the duration of stage 3 is (1...
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