topic Re: Difference with previous data available in DAX Commands and Tips

Difference with previous data available

Ice_82 — Mon, 19 Dec 2022 16:28:24 GMT

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?

Re: Difference with previous data available

amitchandak — Mon, 19 Dec 2022 18:18:07 GMT

Ice_82 , refer if the new offset function can help

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

Re: Difference with previous data available

CNENFRNL — Mon, 19 Dec 2022 20:39:13 GMT

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

Re: Difference with previous data available

Ice_82 — Tue, 20 Dec 2022 09:35:46 GMT

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