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.
ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

Anonymous so for example, are you trying to get value 2016 when you select 2015 in Slicer ?

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi Ankit,

 

Thanks for your quick response. Yes, when I select 2015 in slicer value, then 2016 should be passed as filter in the table do the calculation. I also have one date master table and I tried all the options, but doesn't work.

 

Regards,

Niket Talati