Forum Discussion
MiguelSaldana77
Resolver I
Resolver ICumulative 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 , it doesn´t work. This is the formula
Any Idea ?
Hi, please review the PBIX
https://drive.google.com/file/d/0B95C8CKdTZE3RGtYVU42VTR2b00/view?usp=sharing
10 Replies
- Greg_Deckler
Community Champion
This is likely because of the current context in which your formula is running.
MiguelSaldana77I 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
