6 Replies Latest reply on Jun 25, 2018 4:16 AM by Mavis Liu

    Need help to hide current month and a measure value in dashboard

    raja.reddy.1

      Hi All,

       

      i have a requirement like have data  with a date filed reporting month(Jan -Dec ) and the data is available   till current month (June)  with 3 measure values like Opex, Capex and Opex %. so here i need to hide current month(June)  data with only capex and opex % but i need to display opex for current month along with other 5 months data(Jan- May) Could anyone please help to get the solution for this.

       

      I have created calculated field to hide current month as below but i am unable to hide tht other two measure values in current month.

       

      if(datepart('month', [Reporting Month]) = datepart('month', Today()))   then

          "Hide"

      else

          "show"

       

      its really appreciate if any could help me in this.

       

      Thanks,

      Rajesh.