How to calculate growth a variable over time for each category?

[Mehrheyr]

Hi,

 I am trying to calculate time difference of a variable (daily change and difference from first date) for each category in my workflow, how can I calculate it?

Here is an example of my question, I need to calculate price change and Change from fist date (YTD) for each market over the time.

Thanks,

As of Date	Market	price	change from first date- YTD	price change
4/26/2022	A	100	-	-
4/26/2022	B	20	-	-
4/26/2022	C	50	-	-
4/27/2022	A	110	10	10
4/27/2022	B	18	-2	-2
4/27/2022	C	50	0	0
4/28/2022	A	108	8	-2
4/28/2022	B	20	0	2
4/28/2022	C	52	2	2

[MatthewBr]

Take a look at the attached. Something like this?

[Mehrheyr]

Thank you,
I am looking for something that will not eliminate first date from my data set, also I need to calculate daily growth as well as difference from first date