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,

 

Thanks for your response.

 

I am not able to get what you have written. I have date master table but the thing is next year should be calculate based on the current selected year from Slicer. Could you explain your formula more in detail (in perspective to Year Slicer selection)?

 

Regards,

Niket Talati

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

Next Year Value =

CALCULATE( SUM(Value)  ,PARALLELPERIOD("Your Date Field",-1,YEAR))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi Baskar,

     

    Thanks for the prompt response again.

     

    But it doesn't work either since I do not have continuos dates in the dataset. Here I have attached the screenshot how my data looks. I do not have data for all the dates. 

    How I want - When I select 2016 in Slicer then, it should give me 198840229.71. I hope now I explained my issue propoerly.

     

    Regards,

    Niket Talati

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

      From that date you could select as year,

      then apply the cacl measure

      Measure = CALCULATE(SUM("STD PACK"),PARALLELPERIOD("Date Filed",1,YEAR))

       

       

      Surely its should work , bec its working for me perfectly....

       

      • 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