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.
Hola
Cualquier solución alternativa es posible mostrar la columna Diferencia solo en el año en curso.
No quiero ver la columna amarilla "Diferencia" resaltada
Quiero lucir visualmente
saludos
Carnero
Solved! Go to Solution.
Hola
No estoy seguro de si esto se adapta a lo que desea ver, pero verifique la imagen de abajo y el archivo pbix adjunto.
Desired outcome: =
SWITCH (
TRUE (),
SELECTEDVALUE ( 'Year Type'[Type] ) = "Actual", SUM ( Data[Value] ),
SELECTEDVALUE ( 'Year Type'[Type] ) = "Difference",
IF (
SELECTEDVALUE ( 'Year Type'[Year] ) = YEAR ( TODAY () ),
SUM ( Data[Value] )
- CALCULATE (
SUM ( Data[Value] ),
FILTER (
ALL ( 'Year Type' ),
'Year Type'[Year]
= MAX ( 'Year Type'[Year] ) - 1
)
)
)
)
Hola
No estoy seguro de si esto se adapta a lo que desea ver, pero verifique la imagen de abajo y el archivo pbix adjunto.
Desired outcome: =
SWITCH (
TRUE (),
SELECTEDVALUE ( 'Year Type'[Type] ) = "Actual", SUM ( Data[Value] ),
SELECTEDVALUE ( 'Year Type'[Type] ) = "Difference",
IF (
SELECTEDVALUE ( 'Year Type'[Year] ) = YEAR ( TODAY () ),
SUM ( Data[Value] )
- CALCULATE (
SUM ( Data[Value] ),
FILTER (
ALL ( 'Year Type' ),
'Year Type'[Year]
= MAX ( 'Year Type'[Year] ) - 1
)
)
)
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 |