Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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.
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
21 | |
21 | |
21 | |
13 | |
12 |
User | Count |
---|---|
43 | |
28 | |
25 | |
23 | |
22 |