Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to 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.
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 💡
Proud to be a Super User! | |
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 💡
Proud to be a Super User! | |
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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |