Forum Discussion

jalaomar's avatar
jalaomar
Helper IV
3 years ago
Solved

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...
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    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 _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.