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

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
10 years ago

Cool Niket, 

 I come with solution for you.

 

File --> Oprions and Settings --> Options 

 

Choose Preview Features

 

And here u need to enable the Inline Hirerachy Labels 

 

now check the result. again if not try to create new report in new Page.....

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi Baskar,

     

    This also doesn't work. I tried to create a new report but same issue, returning blank.

     

    Can I send you the pbix file? Can you share your email id?

     

    Thanks again for helping.

     

    Regards,

    Niket Talati