Forum Discussion
jalaomar
3 years agoHelper IV
measure schedule performance
Hi, I have projects with their Tollgate dates (ITG0, ITG0.1 etc.) which is visulized in a matrix table. I have calculated the datediff between Contract Baseline and ActualsSchedule. Now I wou...
- 3 years ago
Hi jalaomar ,
Sorry for late back, I modify the formula:
% Performance = DIVIDE ( DATEDIFF ( MAXX ( FILTER ( ALL ( 'Table' ), 'Table'[Tollgate] = "ITG 0" && 'Table'[Baseline] = "Actual Date" ), 'Table'[Date] ), MAXX ( FILTER ( ALL ( 'Table' ), 'Table'[Baseline] = "Actual Date" && 'Table'[Tollgate] = MAX ( 'Table'[Tollgate] ) ), 'Table'[Date] ), DAY ), DATEDIFF ( MAXX ( FILTER ( ALL ( 'Table' ), 'Table'[Tollgate] = "ITG 0" && 'Table'[Baseline] = "Actual Date" ), 'Table'[Date] ), MAXX ( FILTER ( ALL ( 'Table' ), 'Table'[Baseline] = "Planned Date" && 'Table'[Tollgate] = MAX ( 'Table'[Tollgate] ) ), 'Table'[Date] ), DAY ) )Get the correct result:
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jalaomar
3 years agoHelper IV
Hi v-yanjiang-msft is it possible to share your pbix? I can't stil not make the measure work for me.
Thanks!
v-yanjiang-msft
3 years agoCommunity Support