6 Replies Latest reply: Dec 26, 2016 3:41 AM by vijayakrishna parimi RSS

    Sales from previous year



      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