This topic has 0 replies, 1 voice, and was last updated 6 years, 3 months ago by Frank. Author Posts July 23, 2015 at 3:11 pm #247 FrankKeymaster Topics Started - 80Replies Written - 53 We got the following question from a Stratum user – “Is there a way to use a “Date Based” value in a calculated measure. For example, “This Month” = July = 07, Can I create a calculation that uses the numeric value of “This Month” (7) as part of the calculation?” To get the current month in a calc you can use the datepart function. Datepart(“m”,now()). You can also use w for week number and I think d for day. Author Posts Viewing 0 reply threads You must be logged in to reply to this topic.