Calculate change and change % based on previous date with index item

[Dennisblink]

Hi, I am looking to see if 

Index	Published Date	Avg Price	Change	% Change
item 1	4/5/2023	1.991	-6.705	-77.1
item 1	3/15/2023	8.696	0.246	2.91
item 1	3/14/2023	8.45	-0.208	-2.4
item 1	9/19/2022	8.658	0.086	1
item 1	6/1/2022	8.572
item 2	10/1/2022	2437.63	26.16	1.08
item 2	9/1/2022	2411.47	-168.58	-6.53
item 2	8/1/2022	2580.05	-270.26	-9.48
item 2	7/1/2022	2850.31	-422.61	-12.91
item 2	6/1/2022	3272.92	-274.19	-7.73
item 2	5/1/2022	3547.11	314.01	9.71
item 2	4/1/2022	3233.1	227.5	7.57
item 2	3/1/2022	3005.6	311.05	11.54
item 2	2/1/2022	2694.55	46.81	1.77
item 2	1/1/2022	2647.74	-325.69	-10.95
item 2	12/1/2021	2973.43	119.19	4.18
item 2	11/1/2021	2854.24	251.76	9.67
item 2	10/1/2021	2602.48	97.53	3.89
item 2	9/1/2021	2504.95	61.88	2.53
item 2	8/1/2021	2443.07	-6.61	-0.27
item 2	7/1/2021	2449.68

Hi Power BI people,

I would like to see if this is possible. I have a price field (avg price) that I would like to add a change and change % column next to... these should change based on the index name, so if the index name changes, this should restart the calculation for both change and change % so these fields should remain blank for last entry in the table...

I have been using Power BI for quite some time but I am unsure if this is possible and would love if anyone could help point me in the right direction.

Thanks

[amitchandak]

@Dennisblink , try use offset

Offset Previous Day = CALCULATE([Avg Price],OFFSET(-1, ALLselected('Table'[Published Date],'Table'[Index]),ORDERBY('Date'[Published Date]),,partitionBy('Table'[Index])))

Continue to explore Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U