CURRENTMONTH() ?

[procyon82]

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

[leonardmurphy]

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

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

[procyon82]

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.

[ALeef]

Its: 

MONTH(TODAY())

[procyon82]

MONTH(TODAY()) would give me this month, what about every month?

[procyon82 · Accepted solution]

Figured it out:

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

[Anonymous]

thanks.. that really helped

[MyNameHere]

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

[ALeef]

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.