19 Replies Latest reply: Oct 21, 2017 3:46 PM by Sunny Talwar RSS

    Previous month data on this month row

    Inês Castelhano

      Hi all,

       

      I have a table where I want to show the following expression:

      sum({<ID_Date={"=$(vmaxDateDynamic)"}, [Data Date Type]={"D"}>}[#Jumbo In Process])

      -

      sum( {<ID_Date={"=$(vVarCarrProcDynamic)"}, [Data Date Type]={"D"}>}[#Jumbo In Process])

       

      The dates being shown in the table are correct, and the first expression is correct. However, the second expression keeps returning the value for the Day and Month in that row of  the table, and not for the date I am selecting through the variable.

       

      I already tried to ignore Year, Month and Day and it didn't work. Total will also show me the value for the entire month which is not the desired, so it doesn't work.

       

      Any ideas?

       

      Thanks in advance.

      Regards,

      1.png