2 Replies Latest reply on Jul 30, 2018 6:37 AM by Jim Dehner

    Max Month in Year

    Nitin Uppal

      I want to calculate latest month in an year without using MAX, WINDOW_Max or any function that makes my calculation aggregated.

       

      e.g.

      Month    

      Jan 2016

      Feb 2016

      March 2016

      Jan 2017

      Feb 2017

      March 2017

      Apr 2017

      Jan 2018

      Feb 2018

      Mar 2018

      Apr 2018

      May 2018

       

      My output should be :

       

      Month

      March 2016

      Apr2017

      May 2017

        • 1. Re: Max Month in Year
          Ankit Bansal

          Nitin,

           

          Any reason why you do not want to use max? You can try LOD which you can use with other dimensions also in your view:

           

          {fixed year(date): max(month(date)) }

          • 2. Re: Max Month in Year
            Jim Dehner

            Hi

             

            you can use {fixed:max(month)}   the lod expression is not aggregated even though it contains max(month) - Lod expressions form a different layer in your data but they are not aggregated in themselves - they can be further aggregated in nested LOD, regular calculations or table calculations

             

            Jim

             

            If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.