Cumulative YTD including only past months from current year and corresponding months from prev years

[MiraNi]

I have a Order revenuew YTD measure, which is showing monthly values only for past months in current year and corresponding months in all previous years. DAX for this is:

  CALCULATE(

        [Actual order revenue, sum],

        'Project - Calendar Period'[IsYTD] = TRUE()

        )

Now I need to have similar measure but as cumulative version and cumulative prev year version.

I have already a cumulative YTD measure but it is showing values for all months, not only for months as defined in first measure. DAX for this measure is:

CALCULATE([Actual order revenue, sum], DATESYTD('Project - Calendar Period'[Date]))

How do I get a wanted result, how should I build the measure and the prev year version of it? I have tried so many different ways and there is always a different problem. 

[MiraNi · Accepted solution]

I got a solution somewhere else. There must be different ways to do this but at least DAX below works.

But how about a previous year version of this measure?

var currentDate = CALCULATE( max('Project - Calendar Period'[Date]), 'Project - Calendar Period'[IsYTD] = TRUE() )

var yearnum = CALCULATE( max('Project - Calendar Period'[YearNo]), 'Project - Calendar Period'[IsYTD] = TRUE() )

return

CALCULATE([Actual order revenue, sum],

    ALL('Project - Calendar Period'),

    'Project - Calendar Period'[YearNo] = yearnum,

    'Common - Calendar'[Date] <= currentDate

)

[lbendlin]

Add a filter

 Month('Project - Calendar Period'[Date])<Month(TODAY())