Cumulative Growth Future Months

[rgreben]

Hello!

I am trying to show cumulative percent growth for current year versus prior year. My graph is attached. The calculation for the current year (blue line) is below. How do I get rid of the future months % calculation just for the blue line? It looks like March through December 2020 % growth is set equal to February 2020 % growth.

RangeSum(Above(TOTAL (sum({<[Fiscal Month]=,[Fiscal Year]=,[Fiscal Quarter]=,[Fiscal MonthYear]=,[Calendar.Date]=,
[Fiscal Year]={"$(=max({1}[Fiscal Year]))"}>}NetSales)), 0, RowNo(TOTAL)))

/

RangeSum(Above(TOTAL (sum({<[Fiscal Month]=,[Fiscal Year]=,[Fiscal Quarter]=,[Fiscal MonthYear]=,[Calendar.Date]=,
[Fiscal Year]={"$(=max({1}[Fiscal Year])-1)"},
[Fiscal Month Number] = {"<=$(=max({1<[Fiscal Year]={$(=max({1}[Fiscal Year]))}>} [Fiscal Month Number]))"},
[Nth Day of Fiscal Year]={"<=$(=max({1<[Flag - Apply To All OpCo Business Rule]={'Y'},[Fiscal Year]={$(=max({1}[Fiscal Year]))}>} [PY Nth Day of Fiscal Year]))"}>}NetSales)), 0, RowNo(TOTAL)))

- 1

Thank you.

[sunny_talwar]

May be something like this

If(DateField < MonthStart(Today(1), 1), YourExpressionforBlueLine)