Forum Discussion
MiguelSaldana77
9 years agoResolver I
Cumulative 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
9 years agoResolver I
I 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
9 years agoCommunity Champion
- MiguelSaldana779 years agoResolver I
- Vvelarde9 years agoCommunity Champion
- MiguelSaldana779 years agoResolver I
See the first Imagen at the top