Forum Discussion

Icon for Resolver I rank

Resolver I

10 years ago

Solved

CURRENTMONTH() ?

Curious, there is PREVIOUSMONTH() and NEXTMONTH(), how come there isn't CURRENTMONTH()?

procyon82
10 years ago
Figured it out:

Revenue MTD = CALCULATE(SUM('GA Ecommerce'[Revenue]),PARALLELPERIOD('GA Ecommerce'[Date],0,MONTH))

Icon for Skilled Sharer rank

Skilled Sharer

10 years ago

There's a DATESMTD() - is that what you're looking for?

https://msdn.microsoft.com/en-us/library/ee634359.aspx

Icon for Resolver II rank

Resolver II

10 years ago

Its:

MONTH(TODAY())

procyon82
Resolver I
10 years ago
MONTH(TODAY()) would give me this month, what about every month?
- procyon82
  Resolver I
  10 years ago
  Figured it out:
  
  Revenue MTD = CALCULATE(SUM('GA Ecommerce'[Revenue]),PARALLELPERIOD('GA Ecommerce'[Date],0,MONTH))
  - MyNameHere
    Frequent Visitor
    10 years ago
    Been driving me nuts.
    This should really be a standard function though.

Related content