Forum Discussion

Ykankam's avatar
Ykankam
Helper I
4 years ago
Solved

undefined

How to calculate project progress using start date and end date
Need Help
Show and Tell
Tips and Tricks
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Ykankam 

    Please try formulas like:

    Percentage% =
VAR a =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER ( 'Table', 'Table'[Project] = EARLIER ( 'Table'[Project] ) )
    )
VAR b =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER (
            'Table',
            'Table'[Project] = EARLIER ( 'Table'[Project] )
                && 'Table'[Due Status] = "Not Overdue"
        )
    )
RETURN
    b / a

    or measure

    Percentage1% = 
VAR a =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER ( ALLSELECTED('Table'), 'Table'[Project] = max( 'Table'[Project] ) )
    )
VAR b =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER (
            ALLSELECTED('Table'),
            'Table'[Project] = MAX( 'Table'[Project] )
                && 'Table'[Due Status] = "Not Overdue"
        )
    )
RETURN
    b/a+0

    If it doesn't work, please share a sample file and expected result for further research.

    Best Regards,
    Community Support Team _ Eason