compute sum on columns between 2 dates

[LECOMTE FRANCOISE 2]

I have a table which contains Date-Time value and a measure of Temperature

I would like to be able to calculate the sum of the temperature between 2 dates. .

 

 

 

Date-Time

Temperature

Cumul I Want

Cumul I can do

 

 

01/01/2020 05:00

10

10

 

 

 

01/01/2020 05:10

11

21

21

 

 

01/01/2020 05:11

14

35

35

 

 

02/01/2020 05:20

18

18

53

 

 

02/01/2020 05:25

24

42

77

 

 

02/01/2020 05:30

23

65

90

 

 

03/01/2020 05:35

25

25

115

 

 

03/01/2020 05:40

17

42

132

 

 

03/01/2020 05:45

9

51

 

141

 

 

 

 

Do you have any idea to do that The idea is to calculate the "ssum of degre-days''

[Gaia Paolini]

try this:

first create a column e.g. called [day] with the day of the year: DayOfYear([Date-Time])

then sum like this:

sum([Temperature]) over (Intersect([day],AllPrevious([Date-Time])))

[Fabian Duerr]

1st create a date column to group your data: date([Date-Time])

Then use:Sum([Temperature]) OVER (Intersect(AllPrevious([Date-Time]),[Date]))

[Fabian Duerr]

I was just a little too late :)

[LECOMTE FRANCOISE 2]

it works perfectly ! thanks for your help