Hi everyone,
I have a requirement where I have a day-wise data and need a 90-day value for a measure I'm calculating. I have an additional detail to it where I would like to see the 90-day rate on a week to week basis.
For instance, for week ending Sept 12, it should go last 90 days and sum the measure. Similarly for week ending Sept 5, it should go back 90 days etc. I have come up with the calculation using window functions but it's calculating on a week basis whereas I want the calculation on a day-wise basis.
I have attached the workbook for reference. Any suggestions here would be very helpful.
Thanks
Kanu
Hi, Kanupriya
The question is, for the week start by 12 Sep, there are 2 different values, you just want the last one?
If yes, please find my solution attached.
You need create a calculation with last()=0 and drag it to filter and set up the table calculation, and then select true only
Hope this helps
ZZ
