All dates up to x months ago

[ruthhacche]

I have a table ([orders]) .
I have a parameter ([months]} that takes the number of months ago eg 12
I want a measure that calculates transactions dated before today - 12 months.

something like Sales before selected date = CALCULATE( [sales], FILTER (orders,orders[date]<= ????))

where ???? is today() less [months] - do I use DATEADD somehow?

Any help gratefully received.

 

[MSBINinja]

are you trying the running total? If yes, then you can try this:

Running Total =
VAR LastDateInFilterContext =
    MAX ( Dates[Date] )
VAR MaxYear =
    YEAR ( LastDateInFilterContext )
VAR DatesLessThanMaxDate =
    FILTER (
        ALL ( Dates ),
        Dates[Date] <= LastDateInFilterContext
            && Dates[Calendar Year Number] = MaxYear
    )
VAR Result =
    CALCULATE ( [Total Sales], DatesLessThanMaxDate )
RETURN
    Result

 

[ruthhacche]

Thank you. I did not see this response before.