topic Re: calculation of the accumulated rain of a farm in DAX Commands and Tips

calculation of the accumulated rain of a farm

gelsonwj — Thu, 22 Dec 2022 21:02:02 GMT

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?

Re: calculation of the accumulated rain of a farm

Greg_Deckler — Fri, 23 Dec 2022 00:06:23 GMT

gelsonwj Try:

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

Re: calculation of the accumulated rain of a farm

AlexisOlson — Thu, 22 Dec 2022 23:26:28 GMT

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

Re: calculation of the accumulated rain of a farm

Greg_Deckler — Fri, 23 Dec 2022 00:06:44 GMT

You're right AlexisOlson I edited it.

Re: calculation of the accumulated rain of a farm

v-zhangti — Fri, 23 Dec 2022 08:05:22 GMT

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.

Re: calculation of the accumulated rain of a farm

gelsonwj — Fri, 23 Dec 2022 12:22:20 GMT

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