How to improve the expression to sum or average measures over rolling x weeks
Hi,
Hope to tap your expertise in improving the expression below.
I am using the following expression in a straight table to report the inventory value on Sat 12am every week, for the past 6 weeks. In the straight table, each column is one measure for the data in that day for that week.
Now I would like to have the average inventory value over the 6 weeks. Instead of add all the 6 sum expression then divided by 6, is there anyway to have a simpler expression to do the same?