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

Hi Talat,

 

Please check with the DAX Query

 

Next Year Value = CALCULATE(SUM('Date Master'[DayOfMonth]),PARALLELPERIOD('Date Master'[Date].[Date],-1,YEAR))

 

Let me know it working fine...

 

Note :

Prob with your query is once the context filter apply then next year value we can get it. Tha is the issue.

 

 

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....