4 Replies Latest reply: Mar 21, 2018 8:40 AM by Sunny Talwar RSS

    Set Analysis Date range

    Keti Kvirikashvili

      Hello,

       

      I use this formula in my bar chart.

       

      Sum({<Month = {"$(='>=1<=' & Num(Month(Max({1}Date))))"}, Year>} Measure)


      I have information until March 12 and this calculates me  Sum in January February and March in all of the years. I want to have the sum in all of these years until March 12 . I added the day , but it doesn't work correctly


      Sum({<Month = {"$(='>=1<=' & Num(Month(Max({1}date))))"},

      Day= {"$(='>=1<=' & Num(Day(Max({1}date))))"}, Year>} FactSoldAmount)

       

      Thank you, in advance