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.
v-yanjiang-msft
3 years agoCommunity Support
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 _ kalyj
If 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-msft3 years agoCommunity Support