Summing nine months before each month

Nin_04 — Thu, 28 Mar 2024 09:38:09 GMT

Hello everyone,

I need to create a trend line with dimension [Year Month] interval YTD (jan to current month) and for each month i have to calculate the nine month before. I have already created thi graph with this measure:

Rangesum(above(count(Transaction),9)) and the formula works correctly if I don't apply any filter. The problem is that my dimension have to be a YTD so from January to current month but with this formulas January not include the nine month before.

How can i do?

Thanks a lot!

Re: Summing nine months before each month

F_B — Fri, 17 May 2024 10:51:15 GMT

Hi @Nin_04 ,

here's a suggestion for how you might modify your expression to achieve the desired result:

Rangesum(Above(Count({<[Year Month]={">=$(=Date(AddMonths(MonthStart(Max([Year Month])),-8),'YYYY-MM'))<=$(=Max([Year Month]))"}>} Transaction), 9))

I would like to point out that I didn't test if it works, but I hope it can be helpful

topic Summing nine months before each month in App Development

Summing nine months before each month

Re: Summing nine months before each month