Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to Solution.
@gelsonwj Try:
Measure =
VAR __Table = GROUPBY('Table',[Date],"__Average",AVERAGEX(CURRENTGROUP(),[Value]))
VAR __Result = SUMX(__Table,[__Average])
RETURN
__Result
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.
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.
@gelsonwj Try:
Measure =
VAR __Table = GROUPBY('Table',[Date],"__Average",AVERAGEX(CURRENTGROUP(),[Value]))
VAR __Result = SUMX(__Table,[__Average])
RETURN
__Result
I want to calculate the accumulated each month, something like what's in the picture. How could I do that?
This looks like it's missing the column to group on.
You're right @AlexisOlson I edited it.
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
10 |