Delta Calculation for Duplicated row dates

[almohalhel1408]

hello every body ...

i have this table with duplicate rows for date column

i want to calculate the Delta for "Deaths" only  ? like a Measure

plz help me guys

country   date                                                 status               values     previos date

Spain	04/16/2020	395.570224334054	Recovered		04/15/2020
Spain	04/16/2020	395.570224334054	Active	184948	04/15/2020
Spain	04/16/2020	395.570224334054	Delta_Confirmed	7304	04/15/2020
Spain	04/16/2020	395.570224334054	Deaths	19315	04/15/2020
Spain	04/15/2020	379.948293204569	Recovered		04/14/2020
Spain	04/15/2020	379.948293204569	Active	177644	04/14/2020
Spain	04/15/2020	379.948293204569	Delta_Confirmed	5103	04/14/2020
Spain	04/15/2020	379.948293204569	Deaths	18708	04/14/2020

[Ashish_Mathur]

Hi,

What's in the third column?  There is no title there.  Please show the exact expected result.

[amitchandak · Accepted solution]

@almohalhel1408 ,

You can try a new column like

Diff = [values] - maxx(filter(Table,[country] =earlier([country]) && [status] =earlier([status]) && [date] =earlier([date]) -1),[Value])

This will diff between same status

[almohalhel1408]

thank you sooo much it was like a magic 😙

can you give an explanation how the formula work