متابعة العقود

Planned Value =SUMX (    Contracts,    Contracts[Value] * DIVIDE (        MIN ( MAX ( 'Date'[Date] ), Contracts[End] ) - Contracts[Start],        Contracts[End] - Contracts[Start]    ))Earned Value  = SUM ( Claims[WorkDoneValue] )Actual Cost   = SUM ( Claims[PaidValue] )SPI = DIVIDE ( [Earned Value], [Planned Value] )CPI = DIVIDE ( [Earned Value], [Actual Cost] )Elapsed % = DIVIDE ( [Planned Value], SUM ( Contracts[Value] ) )Spent %   = DIVIDE ( [Actual Cost], SUM ( Contracts[Value] ) )Status =VAR Gap = [Elapsed %] - [Spent %]RETURN    SWITCH (        TRUE (),        ISBLANK ( Gap ), BLANK (),        Gap < 0.10, "Excellent",        Gap < 0.15, "Good",        Gap < 0.20, "Weak",        "At risk"    )

// "Latest row wins" is only safe if the latest row is complete.Latest Claim =VAR LastComplete =    CALCULATE (        MAX ( Claims[ClaimNo] ),        NOT ISBLANK ( Claims[Contractor] ),        NOT ISBLANK ( Claims[Scope] ),        ALLEXCEPT ( Claims, Claims[ContractNo] )    )RETURN    CALCULATE ( SUM ( Claims[WorkDoneValue] ), Claims[ClaimNo] = LastComplete )