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

    Set Analysis Date range

    Keti Kvirikashvili



      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