Forum Discussion
Resolver IEnter measure values for missing months
Hi Guys.
I've got my main table connected with date table. The main table has a column that calculates the Sum of Recycled by month. The data is only till August 2023. I would like to somehow display in a table visual the values till August 2023, and for months after August, the average of values till August 2023.
So basically, from Sep-Dec, just show the average:
Hi, azakir
You can try the following methods.
Measure 2 = Var _aver=DIVIDE(CALCULATE(SUM('Table'[Value]),ALL('Table')),8) Return IF([Measure]=BLANK(),_aver,[Measure])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.
6 Replies
- Idrissshatila
Super User
Hello azakir ,
can you paste both measures here
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
azakirAverage Recycle/Reuse =SUM(Water[TOTAL - Recycled and Reused [kL]]]) / 8- Idrissshatila
Helllo azakir ,
so use this formula instead of the main measure in the table
new measure =
var main = SUM(Water[TOTAL - Recycled and Reused [kL]]]) / 8
var AvgRecycle/Reuse = SUM(Water[TOTAL - Recycled and Reused [kL]]]) / 8
return
if( main = blank(), AvgRecycle/Reuse, main)If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
