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))

ALeef's avatar
ALeef
Resolver II
10 years ago

Its: 

 

MONTH(TODAY())

 

procyon82's avatar
procyon82
Resolver I
10 years ago

MONTH(TODAY()) would give me this month, what about every 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))

    • MyNameHere's avatar
      MyNameHere
      Frequent Visitor
      10 years ago

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

    • ALeef's avatar
      ALeef
      Resolver II
      10 years ago

      That's a much more elegant solution.  I didn't realize your situation and thought you just needed a singular value for a clacluated column or something.  Glad you figured it out.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      thanks.. that really helped