Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hola @chdelgado ,
En función de su descripción, puede hacerlos algunos pasos a continuación.
Real StartDate_column á MINX(FILTER(ALL('Task Manager'), 'Task Manager'[ID Project] ? EARLIER('Task Manager'[ID Project])&&'Task Manager'[Task]<-EARLIER('Task Manager'[Task])), 'Task Manager'[Start Date])
Real EndDate_column : MAXX(FILTER(ALL('Task Manager'), 'Task Manager'[ID Project] á EARLIER('Task Manager'[ID Project])), 'Task Manager'[End Date])
Diff vs StartDates_measure - VALUE([Real StartDate_measure]-MAXX(FILTER(ALL('Project'),[ID Project]-SELECTEDVALUE('Task Manager'[ID Project])),[Schedule Start Date]))
Diff vs EndDates_measure - VALUE([Real EndDate_measure]-MAXX(FILTER(ALL('Project'),[ID Project]-SELECTEDVALUE('Task Manager'[ID Project])),[Schedule End Date]))
Real StartDate_measure á MINX(FILTER(ALL('Task Manager'), 'Task Manager'[ID Project] ? SELECTEDVALUE('Task Manager'[ID Project])&&'Task Manager'[Task]<-MAX('Task Manager'[Task Manager])), 'Task Manager'[Start Date])
Real EndDate_measure á MAXX(FILTER(ALL('Task Manager'), 'Task Manager'[ID Project] ? SELECTEDVALUE('Task Manager'[ID Project])), 'Task Manager'[End Date])
Diff vs StartDates_measure - VALUE([Real StartDate_measure]-MAXX(FILTER(ALL('Project'),[ID Project]-SELECTEDVALUE('Task Manager'[ID Project])),[Schedule Start Date]))
Diff vs EndDates_measure - VALUE([Real EndDate_measure]-MAXX(FILTER(ALL('Project'),[ID Project]-SELECTEDVALUE('Task Manager'[ID Project])),[Schedule End Date]))
Resultado:
Espero que eso sea lo que estabas buscando.
Saludos
Yuna
Si este post ayuda,entonces considere Aceptarlo como la solución para ayudar a los otros miembros a encontrarlo más rápidamente.
Real StartDate á MINX(FILTER(ALL(TaskManager), TaskManager[ID Project] ? EARLIER(TaskManager[ID Project])), TaskManager[Start Date])
Diff vs StartDates á TaskManager[Real StartDate] - RELATED(Projects[ScheduleStartDate])
A continuación, la fecha de finalización seguiría el mismo patrón:
Real EndDate MAXX(FILTER(ALL(TaskManager), TaskManager[ID Project] á EARLIER(TaskManager[ID Project])), TaskManager[End Date])
Diff vs EndDates = TaskManager[Real EndDate] - RELATED(Projects[ScheduleEndDate])
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hey, im tratando de usar esta medida pero me da un error con la función EARLIER, no me deja poner ninguna columna allí