Show data for Year to Date, but in comparison to all previous years

[abloor]

Hi, I'm trying to do a graph that shows all revenue made year to date (from January, only up until the CURRENT month) for all years.  

I created the below, but using a report level filter where I ticked January-June.  I don't want to have to go into the filter each month to add in the latest month, and would prefer to have DAX to tell it to include 'up to and including the current month', and then compare this to the same months in each previous year.

Can anyone help please? Thank you!

[v-chuncz-msft · Accepted solution]

@abloor 

You may try adding the measure below.

Measure =
CALCULATE (
    SUM ( 'Table'[Revenue] ),
    MONTH ( 'Table'[Date] ) <= MONTH ( TODAY () )
)

[abloor]

Thank you @v-chuncz-msft , using your response with a few tweaks I got it to work.  I was basing the revenue off a measure, not a column, so changed it to this:

REVENUE NET YTD =

CALCULATE ([RevenueNet],

MONTH('Calendar'[Month]) <= MONTH(TODAY())

)