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 Gurus,
I have created a measure which has around 5 values against 5 dates. I am looking to find a way to display the average of all those values. Please advise.
Thanks.
Solved! Go to Solution.
hi @amitchandak thank you so much for your input. I tried the way you mentioned but there is a small issue, the value in one of the date does not seem to be right. Please see below image, last column is calculated based on what you mentioned. Column 'OB Cases Shipped Per Lb. Hr." is calculated by dividing "Sum of Total Cases Shipped" by "Sum of Actual Worked Hours". All the values of column three and four are matching except highlighted in the image. Can you please advise why.
Hi,
Share some data to work with and show the expected result very clearly.
@mali130 , try a measure like
Averagex(Values(Date[Date]), [Measure])
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 |
---|---|
112 | |
101 | |
75 | |
65 | |
63 |
User | Count |
---|---|
140 | |
105 | |
102 | |
81 | |
67 |