MTD OR CURRENT MONTH SALES in tableau COUNT(IF MONTH([Submitted Date])=MONTH(TODAY()) THEN [Incident Number] END) The above will calculate the count of [Incident Number] for the current month The above worked like a charm while all the options in the below link failed: https://tableauanalytic.blogspot.com/2019/03/tableau-logical-functions.html