Average Calculation of Values for Multiple Rows

[Anonymous]

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,

[tamerj1]

@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?

[Anonymous]

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. 

[tamerj1 · Accepted solution]

@Anonymous 
Here is a sample file. Hope it helps https://we.tl/t-6C59pmwowt

[tamerj1]

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?

[Anonymous]

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.