Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Modelado de datos con varias columnas de fecha

Hola a todos,

Tengo el siguiente modelo de datos y me gustaría saber cómo calcular los siguientes

DataModel.png

Example1.png

3 REPLIES 3
v-yuaj-msft
Community Support
Community Support

Hola @chdelgado ,

En función de su descripción, puede hacerlos algunos pasos a continuación.

  • Uso de columnas calculadas:
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]))

  • Uso de medidas:
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:

v-yuaj-msft_0-1606701524447.png

v-yuaj-msft_1-1606701524452.png

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.

AllisonKennedy
Super User
Super User

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


Please @mention me in your reply if you want a response.

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

Anonymous
Not applicable

Hey, im tratando de usar esta medida pero me da un error con la función EARLIER, no me deja poner ninguna columna allí

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors