Running Total by Month for multiple Months

[joshua1990]

Hi all!

I have a report with a year and month slicer and a simple bar visual that shows me the running total per Month.

Now I have the issue if I select 2 years, then I get an error. 

MTD = 
CALCULATE (
    [Sales],
    FILTER (
        ALL ( 'Calendar' ),'Calendar'[Date]
                <= MAX ( 'Calendar'[Date] )
            && 'Calendar'[Month Number]
                = MAX ( 'Calendar'[Month Number] )
    )
)

How can I still get a running total for each moth based on the selected year(s) and months?

[tamerj1]

Hi @joshua1990 

what error do you get?

[joshua1990]

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