Forum Discussion
MiguelSaldana77
Resolver I
9 years agoCumulative Total Last Year
Hi, I have a problem with a Last Year Cumulative Total Calculation I need to compare a Monthly Cumulative Total of the Actual Year and Last Year, My problem is with the cumulative Last Year , ...
- 9 years ago
Hi, please review the PBIX
https://drive.google.com/file/d/0B95C8CKdTZE3RGtYVU42VTR2b00/view?usp=sharing
MiguelSaldana77
Resolver I
9 years agoI included SAMEPERIODLASTYEAR to the formula but It doesn´t Acumulate, what is missing?
Ventas Año-1 Cumulative = CALCULATE('Indicadores Vivienda'[Ventas Año-1],FILTER(SAMEPERIODLASTYEAR('Indicadores Vivienda'[Fecha]), 'Indicadores Vivienda'[Fecha] <= MAX('Indicadores Vivienda'[Fecha])))
Vvelarde
Community Champion
9 years ago- MiguelSaldana779 years ago
Resolver I
- Vvelarde9 years ago
Community Champion
- MiguelSaldana779 years ago
Resolver I
See the first Imagen at the top