MTD
Time intelligence
MTD(expr, dateCol)
Exactly YTD scoped to the month. Chart it at a day or week axis — at a month grain each bucket only accumulates itself.
When to use it
Section titled “When to use it”- Daily pacing inside the month — are we tracking to plan by the 15th?
Example
Section titled “Example”RevenueMTD := MTD([Revenue], Date.Date)