3 Replies Latest reply: Sep 6, 2016 3:30 PM by Joaquín Vergara RSS

    Set analysis doesn't work

    Joaquín Vergara

      hi, I have this variable


      =Max(Month)-1  (this results the number of the previus month)


      and I'm trying to calculate the sales of the previous month, but the result is always 0


      1 -  Sum({<Month={'$(PreviousMonth)'}>}[Sales])


      2 -  Sum({<Month={$(=Max(Month)-1)}>} [Sales])