Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
98 | |
79 | |
75 | |
66 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |