Forum Discussion

procyon82's avatar
procyon82
Resolver 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
Resolver I
10 years ago

Figured it out:

 

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

thanks.. that really helped