To calculate the consecutive differences with the specific value chosen using FILTERS and Date slice

[Anonymous]

Hi folks,

I need help in calculating the cosecutive differences between rows with first rows fixed everytime with date slicer and Fund name. The calculations are as follows. Please help me.

READY COLUMN	To Calculate the NEW Columns
Sno	Fund	Return	Price	Date	Start (Sno = 3)
1	A	0.08	108	1/1/2019
2	A	-0.06	101.52	1/2/2019			Calculations -
3	A	0.06	107.6112	1/3/2019
4	A	-0.1	96.85008	1/4/2019	-0.1	1	To Fix the minimum value from COL-F based on minimum date of the slicer and "Fund A"
5	A	0.03	99.7555824	1/5/2019	-0.073	2	For next all the filtered entries -  take the differences from the first value of the column D baesed on the FILTERS of date and FUND(HIGHLIGHTED one)
6	A	0.1	109.7311406	1/6/2019	0.0197
7	A	-0.01	108.6338292	1/7/2019	0.009503
8	A	0.03	111.8928441	1/8/2019	0.03978809
9	A	-0.03	108.5360588	1/9/2019	0.008594447
10	A	0.05	113.9628617	1/10/2019	0.05902417
11	A	-0.02	111.6836045	1/11/2019	0.037843686
12	A	0.02	113.9172766	1/12/2019	0.05860056
13	A	0.07	121.8914859	1/13/2019	0.132702599
14	D	0.03	103	1/1/2019			Same calculations for this fund also
15	D	-0.04	98.88	1/2/2019
16	D	0.02	100.8576	1/3/2019
17	D	-0.02	98.840448	1/4/2019	-0.040384
18	D	-0.09	89.94480768	1/5/2019	-0.12674944
19	D	0.04	93.54259999	1/6/2019	-0.091819418
20	D	-0.08	86.05919199	1/7/2019	-0.164473864
21	D	-0.07	80.03504855	1/8/2019	-0.222960694
22	D	0.08	86.43785243	1/9/2019	-0.160797549
23	D	0.09	94.21725915	1/10/2019	-0.085269329
24	D	0.03	97.04377693	1/11/2019	-0.057827408
25	D	0.08	104.8072791	1/12/2019	0.017546399
26	D	0.09	114.2399342	1/13/2019	0.109125575

[v-joesh-msft]

Hi @Anonymous ,

I'm a little confused by your description. Could you please share more detailed calculation logic for the "Start" column?

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Thanks for your reply. I got the solution.