Forum Discussion
Solved
Difference with previous data available
Hi, I have to calculate the difference with previuous data avaiable, but I dont' have a fix delta time: am val delta 30/11/2022 5000 67% 31/12/2021 3000 50% 31/12/2020 2000 67% ...
Ice_82 , refer if the new offset function can help
Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U
CNENFRNL
Community Champion
Community Champion
For fun only, a showcase of powerful Excel worksheet formula,
Sorry I simplified the real aggregation, my data are grouped in this way:
am liv1 flag val delta 30/11/2022 group1 a 1000 43% b 1500 114% group2 a 1000 11% b 2000 67% 31/12/2021 group1 a 700 17% b 700 40% group2 a 900 13% b 1200 20% 30/11/2021 group1 a 600 b 500 group2 a 800 b 1000 In this situation, how can I modify your code?
Thanks
