Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Tengo que mostrar el valor máximo y el valor Max-1 basado en ID,
No tengo columna de fecha
La columna Max debe mostrar valores solo para Max id y las filas Max-1 deben mostrarse como Blank()
La columna Min debe mostrar valores solo para Max-1 id y Max filas deben mostrarse como Blank()
Solved! Go to Solution.
Hola, @BhavyaM
Si hay alguna otra columna en la tabla para identificar cada fila de datos?
Basándome en la información que usted proporciona actualmente, he modificado su medida original como se indica a continuación:
Max1 =
SWITCH (
TRUE (),
SELECTEDVALUE ( 'A'[ID] ) = MAXX ( ALL ( A ), A[ID] ), SELECTEDVALUE ( A[VALUE] ),
SELECTEDVALUE ( 'A'[ID] ) = MINX ( ALL ( A ), A[ID] ), BLANK ()
)
Min1 =
SWITCH (
TRUE (),
SELECTEDVALUE ( 'A'[ID] ) = MAXX ( ALL ( A ), A[ID] ), BLANK (),
SELECTEDVALUE ( 'A'[ID] ) = MINX ( ALL ( A ), A[ID] ), SELECTEDVALUE ( A[VALUE] )
)
Por favor, revise mi archivo de muestra para más detalles.
Si no cumple con sus requisitos, por favor hágamelo saber.
Saludos
Equipo de soporte de la comunidad _ Eason
Hola, @BhavyaM
Si hay alguna otra columna en la tabla para identificar cada fila de datos?
Basándome en la información que usted proporciona actualmente, he modificado su medida original como se indica a continuación:
Max1 =
SWITCH (
TRUE (),
SELECTEDVALUE ( 'A'[ID] ) = MAXX ( ALL ( A ), A[ID] ), SELECTEDVALUE ( A[VALUE] ),
SELECTEDVALUE ( 'A'[ID] ) = MINX ( ALL ( A ), A[ID] ), BLANK ()
)
Min1 =
SWITCH (
TRUE (),
SELECTEDVALUE ( 'A'[ID] ) = MAXX ( ALL ( A ), A[ID] ), BLANK (),
SELECTEDVALUE ( 'A'[ID] ) = MINX ( ALL ( A ), A[ID] ), SELECTEDVALUE ( A[VALUE] )
)
Por favor, revise mi archivo de muestra para más detalles.
Si no cumple con sus requisitos, por favor hágamelo saber.
Saludos
Equipo de soporte de la comunidad _ Eason
Estoy considerando el ID más reciente y más reciente-1 y calculándolo el valor.
Id | Valor | Valor de identificación actual | Valor de ID anterior |
2020121713 | 1254.39 | 1254.39 | 1254.39 |
2020121713 | 1254.39 | 1254.39 | 1254.39 |
2020121713 | 1254.39 | 1254.39 | 1254.39 |
2020121713 | 1254.39 | 1254.39 | 1254.39 |
2020121713 | 0.332 | 0.332 | 0.332 |
2020121713 | 0.332 | 0.332 | 0.332 |
2020121713 | 0.332 | 0.332 | 0.332 |
2020121713 | 0.332 | 0.332 | 0.332 |
2020121713 | 0.332 | 0.332 | 0.332 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 258.491 | 258.491 | 258.491 |
2020121617 | 258.491 | 258.491 | 258.491 |
2020121617 | 276.955 | 276.955 | 276.955 |
2020121617 | 258.491 | 258.491 | 258.491 |
2020121617 | 258.491 | 258.491 | 258.491 |
2020121617 | 276.955 | 276.955 | 276.955 |
2020121617 | 3442.63 | 3442.63 | 3442.63 |
2020121617 | 258.491 | 258.491 | 258.491 |
2020121617 | 3442.63 | 3442.63 | 3442.63 |
2020121617 | 3442.63 | 3442.63 | 3442.63 |
2020121617 | 3442.63 | 3442.63 | 3442.63 |
2020121617 | 3442.63 | 3442.63 | 3442.63 |
2020121617 | 0.916 | 0.916 | 0.916 |
2020121617 | 0.916 | 0.916 | 0.916 |
2020121617 | 0.916 | 0.916 | 0.916 |
2020121617 | 0.916 | 0.916 | 0.916 |
2020121617 | 0.916 | 0.916 | 0.916 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
@BhavyaM , Todos los valores son los mismos, ¿Cómo será min y max diferentes?
¿Puede compartir datos de ejemplo y salida de ejemplo en formato de tabla? O una muestra de pbix después de eliminar datos confidenciales.
Estoy considerando el ID más reciente y más reciente-1 y calculándolo el valor.
Id | Valor | Valor de identificación actual | Valor de ID anterior |
2020121713 | 1254.39 | 1254.39 | 1254.39 |
2020121713 | 1254.39 | 1254.39 | 1254.39 |
2020121713 | 1254.39 | 1254.39 | 1254.39 |
2020121713 | 1254.39 | 1254.39 | 1254.39 |
2020121713 | 0.332 | 0.332 | 0.332 |
2020121713 | 0.332 | 0.332 | 0.332 |
2020121713 | 0.332 | 0.332 | 0.332 |
2020121713 | 0.332 | 0.332 | 0.332 |
2020121713 | 0.332 | 0.332 | 0.332 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 0 | 0 | 0 |
2020121617 | 276.955 | 276.955 | 276.955 |
2020121617 | 3442.63 | 3442.63 | 3442.63 |
2020121617 | 258.491 | 258.491 | 258.491 |
2020121617 | 3442.63 | 3442.63 | 3442.63 |
2020121617 | 3442.63 | 3442.63 | 3442.63 |
2020121617 | 3442.63 | 3442.63 | 3442.63 |
2020121617 | 3442.63 | 3442.63 | 3442.63 |
2020121617 | 0.916 | 0.916 | 0.916 |
2020121617 | 0.916 | 0.916 | 0.916 |
2020121617 | 0.916 | 0.916 | 0.916 |
2020121617 | 0.916 | 0.916 | 0.916 |
2020121617 | 0.916 | 0.916 | 0.916 |
2020121617 | 0 | 0 | 0 |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.