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.
sdjensen's avatar
sdjensen
Solution Sage
10 years ago

Hi,

 

Try this formula

    CALCULATE ( 
        SUM( 'Sheet5'[Value] ); 
        PARALLELPERIOD( Periode[Date]; 12; MONTH ) 
    )

 

I am sure you will need a seperate date table to have the time intelligence function working properly. If you dont already have a date table you could try to read here... https://www.powerquery.training/portfolio/dynamic-calendar-table/

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi Sdjensen,

 

Thanks for your response.

 

I have a date master table and I tried your formula, but doesn't work for me. I have Year slicer and according to the selected year, next year (suppose I select 2015, then 2016 should be passed in that DAX) should be passed in DAX and do the calculation.

 

Regards,

Niket Talati