1 Reply Latest reply on Jul 13, 2018 1:16 AM by kumar bharat

    Create the measure which calculate the average sale of last 13 month

    Saharat Sakulsaowapakkul

      Hi everyone,

       

      I want to create the measure call "Target Sale" which is the average of [Sale] for 13 month previously.

       

      Example If [Date] = January 2017 then AVG([Sales]) of March 2017 and 12 months earlier which are Feb 17, Jan 17, Dec 16, Nov 16, Oct 16, Sep 16, Aug 16, Jul 17, Jun 17, May 17, Apr 17.

       

      In stead of showing 0, I want it to show the above logic.

       

      Hopefully you guys understand my issue and give me an advice or revise the attached workbook.

       

      Thank you in advance.