calculation of the accumulated rain of a farm

[gelsonwj]

I would like to calculate the accumulated rainfall of several farms, but for that, I need to calculate the daily average and at the end add these averages. How to do this?

[Greg_Deckler · Accepted solution]

@gelsonwj Try:

Measure =
  VAR __Table = GROUPBY('Table',[Date],"__Average",AVERAGEX(CURRENTGROUP(),[Value]))
  VAR __Result = SUMX(__Table,[__Average])
RETURN
  __Result

[v-zhangti · Accepted solution]

Hi, @gelsonwj 

Date = LEFT([Start],9)

Then change the data format of this column to Date.

Column:

Average = CALCULATE(AVERAGE('Table'[Value]),ALLEXCEPT('Table','Table'[Date]))

Measure = 
Var _table=SUMMARIZE('Table','Table'[Date],'Table'[Average])
Return
SUMX(_table,[Average])

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[Greg_Deckler · Accepted solution]

@gelsonwj Try:

Measure =
  VAR __Table = GROUPBY('Table',[Date],"__Average",AVERAGEX(CURRENTGROUP(),[Value]))
  VAR __Result = SUMX(__Table,[__Average])
RETURN
  __Result

[gelsonwj]

I want to calculate the accumulated each month, something like what's in the picture. How could I do that?

[AlexisOlson]

This looks like it's missing the column to group on.

[Greg_Deckler]

You're right @AlexisOlson I edited it.