Work out total number of sales for past 13 month period

[Anonymous]

Hi,

I am wanting to sum the sales

(revenue) for the 13 past 13 month in a measure.

What would the code be to do this

Im thinking something like

=Calculate(sum(revenue),datesbetween(dateadd(calender(date),-13,Month),dateadd(today))

But it doesnt work.

C

[Framet]

I'm not sure you can have dateadd(today)

what about:

=
CALCULATE (
    SUM ( [revenue] ),
    DATESBETWEEN (
        calendar[date],
        DATEADD ( TODAY(), -13, MONTH ),
        TODAY ()
    )
)

[Anonymous]

Thanks for getting back, unfortunatly I am still receiving an error.

A table of Multiple values was supplied where a single value was expected

I amended the revenue to column3 as that is what it is called in the database. 

=CALCULATE (
SUM ( [Column3] ),
DATESBETWEEN (
Calendar1[Date],
DATEADD ( Calendar1[Date], -13, MONTH ),
TODAY ()
)
)

[Framet · Accepted solution]

DateADD shouldn't look at a column but instead I assume you want it to be Today(). This will create a measure that always looks at 13 months from today. If you want 13 months from the selected date then it will need to be something like FirstDate(Calendar1[date]) as the first dateadd paparmeter.

[Anonymous]

Brill! Works a treat!