Forum Discussion

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

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

ALeef
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))
procyon82
Resolver I
10 years ago
I'm trying to calculate the monthly average order size in dollars. My data is listed in daily format. When I create a chart I can add my data and select average and it will display the average daily data nicely. The problem is once you are looking for a weekly or monthly average you end up getting an average of all the daily averages which is close but incorrect.

Revenue MTD = CALCULATE(SUM('GA Ecommerce'[Revenue]),DATEADD('GA Ecommerce'[Date],0,MONTH)) gives me daily revenue
Revenue MTD = CALCULATE(SUM('GA Ecommerce'[Revenue]),MONTH('GA Ecommerce'[Date])) gives me the all time total
Revenue MTD = CALCULATE(SUM('GA Ecommerce'[Revenue]),DATESMTD('GA Ecommerce'[Date])) gives me daily MTD

Previous Month = CALCULATE(SUM('GA Ecommerce'[Revenue]),PREVIOUSMONTH('GA Ecommerce'[Date])) and
Next Month = CALCULATE(SUM('GA Ecommerce'[Revenue]),NEXTMONTH('GA Ecommerce'[Date])) give me exactly what I want but for the wrong month.

Related content