Enter measure values for missing months

[azakir]

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:

[Idrissshatila]

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 💡

[azakir]

Average 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 💡

[azakir]

Hi @Idrissshatila Thanks for your reply, but that didn't help: 

[v-zhangti · Accepted solution]

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.

[azakir]

Hi @v-zhangti This did the trick. Thank you so much for that.