Forum Discussion

Ykankam

Helper I

4 years ago

Solved

undefined

How to calculate project progress using start date and end date

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

v-easonf-msft

Community Support

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

Ykankam

Helper I

4 years ago

v-easonf-msft VahidDM thank you both. It worked.

How do create a dax formula to show all projects startinng next month and another one to show all projects ending this month?