Forum Discussion
Average Calculation of Values for Multiple Rows
Hi,
I am new to PowerBI, and I have an assignment to complete using PowerBI.
Summary of my case.
I have different equipment names. Then for each equipment, I have differnt output values at differnt time time intervals.
I want to calculate and display the average value of some specific equipment names for specific period of time. For example, I want to shown on my dashboard that what was the average value of the equipment A and B over the last 30 days.
P.S: In actual data, there are thousand of timestamps.
Here is my sample data.
| Equipment Names | Time of Event | Output values |
| A | 14/03/2001 13:30 | 1.5 |
| A | 15/03/2002 13:31 | 2.69 |
| A | 16/03/2001 01:33 | 3.88 |
| A | 17/03/2001 03:30 | 5.07 |
| A | 18/03/2001 13:40 | 6.26 |
| A | 19/03/2001 12:30 | 7.45 |
| A | 20/03/2001 01:30 | 8.64 |
| B | 21/03/2001 00:30 | 9.83 |
| B | 22/03/2001 13:00 | 11.02 |
| B | 23/03/2001 19:30 | 12.21 |
| C | 24/03/2001 01:31 | 13.4 |
| C | 25/03/2001 13:32 | 14.59 |
| D | 26/03/2001 13:33 | 15.78 |
| D | 27/03/2001 13:43 | 16.97 |
| D | 28/03/2001 13:53 | 18.16 |
| D | 29/03/2001 13:28 | 19.35 |
| D | 30/03/2001 13:25 | 20.54 |
| E | 31/03/2001 13:24 | 21.73 |
| E | 01/04/2001 13:14 | 22.92 |
| E | 02/04/2001 13:13 | 24.11 |
| E | 03/04/2001 13:12 | 25.3 |
| E | 04/04/2001 13:11 | 26.49 |
| E | 05/04/2001 13:59 | 27.68 |
| E | 06/04/2001 13:21 | 28.87 |
I would really appreciate if somebody could help me please. Many thanks.
Best Regards,
Anonymous
Here is a sample file. Hope it helps https://we.tl/t-6C59pmwowt
5 Replies
Hi Anonymous
Would you please provide the expected results based on the given sample data? What can of visual(s) are you planning to use to disply the results?The expected results are the average values. For instance, the average value of equipment A for the last 30 days is = XYZ. Then, I want to display this number in the dashboard probably by using a Gauge, Card, or Multi-row card.
I believe, if the values are calculated, then plotting and displaying is not that complicated.
Anonymous
Then what is the problem with simple AVERAGE function? It will be automatically filtered by the selected equipment and the date/time range. Unless you are looking for a moving average over the past 30 days from the selected date?Please help me in calculating the simple Average. I assume it would be simple, but I am not figure it out. I really don't know how to calculate the average for a given equipment for multiple timestamps value. Since all the equipments values are written in the same column, then how to filter the values for one specific equipment to take average.
Anonymous
Here is a sample file. Hope it helps https://we.tl/t-6C59pmwowt