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])