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
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