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

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