1 ACCEPTED SOLUTION
Pruebe esta columna calculada en la Tabla 1:
NUMERO DE TURNO =
VAR vResource = Table1[RESOURCE]
VAR vStartDate = Table1[START DATE]
VAR vEndDate = Table1[END DATE]
VAR vTeam = Table1[TEAM]
VAR vTable2 =
FILTER (
Table2,
Table2[RESOURCE] = vResource
&& Table2[START DATE] = vStartDate
&& Table2[END DATE] = vEndDate
&& Table2[TEAM] = vTeam
)
VAR vResult =
MAXX ( vTable2, Table2[NUMERO DE TURNO] )
RETURN
vResult
Pruebe esta columna calculada en la Tabla 1:
NUMERO DE TURNO =
VAR vResource = Table1[RESOURCE]
VAR vStartDate = Table1[START DATE]
VAR vEndDate = Table1[END DATE]
VAR vTeam = Table1[TEAM]
VAR vTable2 =
FILTER (
Table2,
Table2[RESOURCE] = vResource
&& Table2[START DATE] = vStartDate
&& Table2[END DATE] = vEndDate
&& Table2[TEAM] = vTeam
)
VAR vResult =
MAXX ( vTable2, Table2[NUMERO DE TURNO] )
RETURN
vResult
Helpful resources
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
