Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Next Year calculation (dynamically) through FILTER() and Slicer

Hi All,   I am trying to get next year value (dynamically through Year Slicer), but not able to do that. I am using below DAX to calculate next year value. It is returning blank.   Measure = CALC...
Need Help
  • Vvelarde's avatar
    Vvelarde
    10 years ago
    hi Anonymous
     
    This should works
     
    Medida-SUMofValues-NextYear =
    VAR Next_Year =
        IFERROR ( VALUES ( 'Tabla Años'[Year] ) + 1; BLANK () )
    RETURN
        CALCULATE ( SUM ( 'Tabla Años'[Value] ); 'Tabla Años'[Year] = Next_Year 
     
    Let me know.
Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
10 years ago

[email protected]

 

Can u please share how to u solved the issue it will help others.

 

if okay then close the ticket

 

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi Baskar,

 

One of the provided solution worked. I have selected the correct answer. 

 

Regards,

Niket Talati