Forum Discussion
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% |
| 31/06/2020 | 1200 |
With a defined period (11 moth) no problem
DELTA = (SUM(table[val])-CALCULATE(SUM(table[val]),PARALLELPERIOD(table[am],-11,MONTH)))/CALCULATE(SUM(table[val]),PARALLELPERIOD(table[am],-11,MONTH))
But if the period is not fixed which is the solution?
Ice_82 , refer if the new offset function can help
Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U
3 Replies
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
