Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hola,
Alguien sabría como poner el cálculo acumulado debajo de los totales mensuales tal y cómo se muestra en el ejemplo?.
Gracias
22 de octubre | 22 de noviembre | dic-22 | ene-23 | 23 de febrero | mar-23 | TOTAL | |
ingresos | 10 | 20 | 30 | 40 | 50 | 60 | 210 |
Gasto | -18 | -15 | -7 | -19 | -34 | -55 | -148 |
Total | -8 | 5 | 23 | 21 | 16 | 5 | 62 |
Total Acum. | -8 | -3 | 20 | 41 | 57 | 62 |
Solved! Go to Solution.
Hi
Create measure like the below(use the new measure as value):
TEST =
IF (
HASONEVALUE ( 'Table'[Type1] ),
MAX ( 'Table'[value] ),
CALCULATE ( MAX ( 'Table'[value] ), FILTER ( 'Table', 'Table'[Type1] = "A" ) )
- CALCULATE ( MAX ( 'Table'[value] ), FILTER ( 'Table', 'Table'[Type1] = "B" ) )
)
Best Regards
Lucien
Hi
Create measure like the below(use the new measure as value):
TEST =
IF (
HASONEVALUE ( 'Table'[Type1] ),
MAX ( 'Table'[value] ),
CALCULATE ( MAX ( 'Table'[value] ), FILTER ( 'Table', 'Table'[Type1] = "A" ) )
- CALCULATE ( MAX ( 'Table'[value] ), FILTER ( 'Table', 'Table'[Type1] = "B" ) )
)
Best Regards
Lucien
Thanks Lucien,
Pero necesito que el cálculo del "CF ACUM" esté bajo "CASH FLOW" es decir en una fila y no me deja, sólo me deja añadir la medida en la columna.