Krish on 19 Jan 2019 10:59:11
If there is a table with a Field | field
I would like to see Month() | rolling sum of Measure field.
Here Rolling Sum of Measure == Say it should sum up the value in the measure field for the past 12 months and show it against each Month.
i.e. Apr 2019 should show sum of measures from 01 Apr 2018 to 31 MAr 2018
May 2019 Should show sum of measures from 01May 2018 to 30 Apr 2019
- Comments (1)
RE: Rolling past 12 months sum of a measure field against each month
I have the same need and I want to support this idea.
For example,
this solution would be very useful to compare 12 months periods turnover of a business with seasonal characteristics.
Sum of field values for:
Period1 = from April 1, 2019 to March31, 2020
Period2 = from May1, 2019 to April30, 2020
Period3 = from June1, 2019 to May31, 2020
and so on...
If we compare turnovers with rolling 12 months period, we can sterilize the influence of the season, because every period contains always each month of the year.
I made a solution for myself with a formula, but it is a complex job, because I have to create a new calculated column for each data value and each filtered data value.
For a detailed analysis it becomes a very long work.