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


      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





      its really appreciate if any could help me in this.