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.
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi Baskar,

 

I followed the same steps, but still it is returning blank. I have attached below screenshot.

 

DataReport

Please let me know where I am wrong?

 

Thank you,

Niket Talati

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
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.
  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Thank you bro! It works!!

  • 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