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

    • 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

        Thank you bro! It works!!

    • 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