Forum Discussion
isrark
3 years agoFrequent Visitor
Rolling sum for last 3 months giving same value as current month
Hi I'm trying to achieve rolling sum for last 3 months from my current record. I have sample data like below State | Town | Block | Period | Consumption A | a1 | ab1 | 10/1/2022...
- 3 years ago
I found a solution to my problem,
1.I created a calender series table first which has start of the month dates only. added relation to the fact table
2.I created a measure for actual sum value
3.Then using a measure i computed sum of 3 months including current month
4.Then using a measure i got the previous month value from measure (point 3)
- isrark3 years agoFrequent Visitor
yes, i'm still getting same result as consumption record. is there any way to provide filter to the query to select records as per block - town - state combination and check for sum of last 3 months?