Compare 2 values that are 1 week separated

[LouisB]

Hello guys,

I was looking at a method to compare 2 values (of the column Total) separated by 1 Week.

The data are the number of Stars of different Apps. I just want to have the number of new stars by week and by app.

For example:

 Hive: on the 24/09/2018, I want a new column with the value:  8 (=7264 - 7256)

Thank you for your help !

Here it is my table:

Date Brand 1Star 2Star 3Star 4Star 5Star Total Objective Average

24/09/2018	Hive	2469	806	830	1072	2087	7264	4	2,931442731
24/09/2018	Legrand Thermostat	2	0	0	3	11	16	4	4,3125
24/09/2018	Qivivo Thermostat	36	21	22	34	12	125	4	2,72
24/09/2018	Somfy	6	5	24	92	148	275	4	4,349090909
24/09/2018	Netatmo Energy	487	251	363	1935	6832	9868	4	4,456627483
24/09/2018	Ween	1	0	0	4	13	18	4	4,555555556
24/09/2018	tado°	998	512	1546	6514	21760	31330	4	4,516948612
17/09/2018	Somfy	6	5	21	90	146	268	4	4,361940299
17/09/2018	Qivivo Thermostat	35	21	22	34	12	124	4	2,733870968
17/09/2018	Netatmo Energy	486	252	365	1922	6765	9790	4	4,453319714
17/09/2018	Hive	2467	804	828	1070	2087	7256	4	2,931918412
17/09/2018	Ween	1	0	0	4	13	18	4	4,555555556
17/09/2018	tado°	984	506	1541	6433	21511	30975	4	4,516739306
17/09/2018	Legrand Thermostat	1	0	0	3	11	15	4	4,533333333
10/09/2018	Hive	2461	797	824	1067	2083	7232	4	2,932798673
10/09/2018	Legrand Thermostat	1	0	0	3	11	15	4	4,533333333
10/09/2018	Ween	1	0	0	4	13	18	4	4,555555556
10/09/2018	Qivivo Thermostat	35	21	22	34	12	124	4	2,733870968
10/09/2018	Somfy	6	5	19	89	141	260	4	4,361538462
10/09/2018	Netatmo Energy	484	252	362	1902	6721	9721	4	4,452936941
10/09/2018	tado°	967	500	1526	6378	21250	30621	4	4,51673688

[ofirk · Accepted solution]

Hi,

I think this column would work (replace Table1 with your table name...):

column = [Total] - SUMX(FILTER(Table1, [Brand] = EARLIER([Brand]) && (EARLIER([Date]) - [Date])= 7), [Total])

[LouisB]

You are awesome @ofirk !