Difference with previous data available

[Ice_82]

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?

[CNENFRNL]

For fun only, a showcase of powerful Excel worksheet formula,

[Ice_82]

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

[amitchandak · Accepted solution]

@Ice_82 , refer if the new offset function can help

Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U