I'm trying to make this measure
(integrated metric minus yyz metric )/5 for each month
metric being revenue etc.
eg for November 21 revenue
(90,826 - 14,448)/5 = 15,276
then have the formula do that for the rest of the months and metrics ...eg
December 21 revenue
(77,810 minus 12,708)/5
etc
eventually going all the way down where the last calculation would be for October 2022 cash
(34,324 minus 5,036)/5
sample data is here
(integrated metric minus yyz metric )/5 for each month
metric being revenue etc.
eg for November 21 revenue
(90,826 - 14,448)/5 = 15,276
then have the formula do that for the rest of the months and metrics ...eg
December 21 revenue
(77,810 minus 12,708)/5
etc
eventually going all the way down where the last calculation would be for October 2022 cash
(34,324 minus 5,036)/5
sample data is here
Sample Data.xlsx
All Metric,Date,Value Revenue,11/01/21,172936 Revenue,12/01/21,155420 Revenue,1/01/22,194878 Revenue,2/01/22,148203 Revenue,3/01/22,138443 Revenue,4/01/22,135335 Revenue,5/01/22,113300 Revenue,6/01/22,122579 Revenue,7/01/22,116212 Revenue,8/01/22,108952 Revenue,9/01/22,131658 Revenue,10/01/22,13...
docs.google.com