Cumulative Growth Future Months

rgreben — Wed, 05 Feb 2020 16:22:43 GMT

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.

Re: Cumulative Growth Future Months

sunny_talwar — Thu, 06 Feb 2020 12:50:38 GMT

May be something like this

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

topic Cumulative Growth Future Months in App Development

Cumulative Growth Future Months

Re: Cumulative Growth Future Months