undefined

[Ykankam]

How to calculate project progress using start date and end date

[Ykankam]

From the image above. I have a list of projects with start date and end date. Each project has a status.

Now I want a column that will calculate the aggregated completion rate(percentage) for each project base on the start date and end date.

[v-easonf-msft · Accepted solution]

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]

@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?

[VahidDM]

@Ykankam 

Your question is general without any details, check these links and add more details:
 https://community.powerbi.com/t5/Desktop/Progress-Tracker/m-p/1250192

https://community.powerbi.com/t5/Desktop/Create-Progress-Tacker/m-p/2184039

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

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube