Rastreador de progreso

Hola @LuisGerardoSR ,

Crea algo como esto.

Columna calculada

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

Medidas

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")

saludos
Harsh Nathani

Apreciar con un Kudos!! (Haga clic en el botón Pulgares arriba)
¿He respondido a tu pregunta? ¡Marca mi puesto como una solución!