6 Replies Latest reply: Dec 26, 2016 3:41 AM by vj kri RSS

    Sales from previous year

    Nicolas Ludovicy

      Hi,

       

      I'm trying to display number on chart. Those number are monthly sales from the current year compare with the last year.

       

      To display the current year; no problem ; --> Sum([Gross Order]

       

      But to display the one from previous year, I don't get it;

       

      I have try

       

      WIth the year : Sum({<Year={$(=max(Year)-1)}>}[Gross Order])

       

      or with the month : Sum({<Month={$(=max(Month)-12)}>}[Gross Order])

       

      None of them works.

       

      Can anyone help me?

       

      P.S. : The dimension I have is DATE which is on the format dd/mm/yy .

       

       

      Thanks in advance