Progress Tracker

Hi Anonymous ,

Create something like this.

Calculated Column

ESTIMATED START DATE1 =
VAR prevdate =
    CALCULATE (
        MAX ( 'Table'[Begin Date] ),
        FILTER (
            'Table',
            'Table'[Begin Date]
                < EARLIER ( 'Table'[Begin Date] )
        )
    )
VAR est =
    CALCULATE (
        MAX ( 'Table'[Estimated Days] ),
        FILTER (
            'Table',
            'Table'[Begin Date] = prevdate
        )
    )
RETURN
    est + prevdate

Measures

Did it start on Estimate Date =
VAR _datediff =
    DATEDIFF (
        MAX ( 'Table'[ESTIMATED START DATE1] ),
        MAX ( 'Table'[Begin Date] ),
        DAY
    )
RETURN
    IF (
        _datediff = 0,
        "Yes",
        "No"
    )

Overdue =
VAR _datediffactivitybeginend =
    DATEDIFF (
        MAX ( 'Table'[Begin Date] ),
        MAX ( 'Table'[End Date] ),
        DAY
    )
RETURN
    IF (
        _datediffactivitybeginend
            > MAX ( 'Table'[Estimated Days] ),
        "Overdue",
        "On-Time"
    )

Project Overdue = 
var _beginactivity = CALCULATE(MIN('Table'[Begin Date]),ALL('Table'))---Date of 1st Task of project
var _endactivity = CALCULATE(MAX('Table'[End Date]),ALL('Table'))

var _datediffactivitybeginend = CALCULATE( DATEDIFF(_beginactivity,_endactivity,DAY))

RETURN

IF(_datediffactivitybeginend <= SUM('Table'[Estimated Days]), "On-Time","OverDue")

Regards,
Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

Hi Anonymous ,

Maybe you can do like this.

IF suggested date = 
IF(
    MAX(Sheet5[Begin Date]) = DATE(2020, 8, 27),
    "Yes", "No"
)

How much progress = 
CALCULATE(
    COUNT(Sheet5[Task]),
    ALLEXCEPT( Sheet5, Sheet5[Task])
)

If the activity is over = 
VAR x = 
DATEDIFF(
    MAX(Sheet5[Begin Date]),
    MAX(Sheet5[End Date]),
    DAY
)
RETURN
IF(
    x > MAX(Sheet5[Estimated Days]),
    "Yes", "No"
)

If the whole project is over due = 
VAR x = 
DATEDIFF(
    MAX(Sheet5[Begin Date]),
    MAX(Sheet5[End Date]),
    DAY
)
RETURN
IF(
    x > 84,
    "Yes", "No"
)

But to be honest, your data lacks completeness. If this is not what you want, please provide a more complete data table, including more key columns and duplicate rows.

Best regards,
Lionel Chen

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