Forum Discussion
jalaomar
Helper IV
3 years agomeasure 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
Helper IV
3 years agoHi v-yanjiang-msft , thanks for looking into this.
but so wierd, have tried several times and i am getting the following error when trying your measure. Do you know why?
v-yanjiang-msft
Community Support
3 years agoHi jalaomar ,
Maybe your fact data is more complicated than my sample, you can seperately return each part in the formula to check which part can't get the correct result than dig it.
Best Regards,
Community Support Team _ kalyj