Forum Discussion

procyon82's avatar
procyon82
Icon for Resolver I rankResolver I
10 years ago
Solved

CURRENTMONTH() ?

Curious, there is PREVIOUSMONTH() and NEXTMONTH(), how come there isn't CURRENTMONTH()?
Need Help
  • procyon82's avatar
    procyon82
    10 years ago

    Figured it out:

     

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

procyon82's avatar
procyon82
Icon for Resolver I rankResolver I
10 years ago

Figured it out:

 

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

MyNameHere's avatar
MyNameHere
Frequent Visitor
10 years ago

Been driving me nuts. 
This should really be a standard function though.