Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
@chrismcdonald , Pruebe uno de los dos
Columna Real del proyecto (nivel de proyecto) =
SI (
CALCULAR (
COUNTBLANK ( «Tabla1»[actual_date] ),
ALLEXCEPT ('Tabla1', 'Tabla1'[project_id] )
) > 0,
EN BLANCO (),
CALCULATE ( MAX ( 'Table1'[actual_date] ), filter('Project type','Project type'[task_type] = "D1" ), ALLEXCEPT ('Table1', 'Table1'[project_id] )
)
o
Columna Real del proyecto (nivel de proyecto) =
SI (
CALCULAR (
COUNTBLANK ( «Tabla1»[actual_date] ),
ALLEXCEPT ('Tabla1', 'Tabla1'[project_id] )
) > 0,
EN BLANCO (),
CALCULATE (CALCULATE ( MAX ( 'Table1'[actual_date] ), filter('Project type','Project type'[task_type] = "D1")), ALLEXCEPT ('Table1', 'Table1'[project_id] )
)