Accumulate value from the beginning of year to the current month in calculation

[A_Jafery]

Hi,

I want to calculate 

Calc1 = Billed Revenue in Jun (current) till  Jan / Total Billed Revenue

I do to like this, but it only show the Jun only not from the beginning of year

Sum({[SPM Year]={'$(vMaxYear)'},[SPM Est Close Month] = {'$(vMaxMonth2)'}>}[Est. Billed Revenue For Current Year]))/(sum({<[SPM Year]={'$(vMaxYear)'}>}[Est. Billed Revenue For Current Year]))

[Arthur_Fong]

Try this:

Sum({[SPM Year]={'$(vMaxYear)'},[SPM Est Close Month] = {"<=$(vMaxMonth2)"}>}[Est. Billed Revenue For Current Year]))/(sum({<[SPM Year]={'$(vMaxYear)'}>}[Est. Billed Revenue For Current Year]))

[A_Jafery · Accepted solution]

Thank you for the formula.

But I have to change the month to be in Num to use the <=.

Sum({[SPM Year]={'$(vMaxYear)'},[SPM Num Month]= {'<=$(vMonthNum)'}>}[Est. Billed Revenue For Current Year]))/(sum({<[SPM Year]={'$(vMaxYear)'}>}[Est. Billed Revenue For Current Year]))