Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Calculate the average value Accumulator hour

Community.!!!

I need to create a column, table, or measure that contains an average hour value for a series of records. The dataset is as follows:

Fecha_Hora Nivel_1
17/03/2022 11:00 1139969
17/03/2022 11:15 1140002
17/03/2022 11:30 1139991
17/03/2022 11:45 1139991
17/03/2022 12:00 1139969
17/03/2022 12:15 1139991
17/03/2022 12:30 1140002
17/03/2022 12:45 1139991
17/03/2022 13:00 1139969
17/03/2022 13:15 1139991
17/03/2022 13:30 1139991
17/03/2022 13:45 113998
17/03/2022 14:00 1140002
17/03/2022 14:15 1140002
17/03/2022 14:30 1139991
17/03/2022 14:45 1140002
17/03/2022 15:00 113998
17/03/2022 15:15 1139991
17/03/2022 15:30 1139991
17/03/2022 15:45 1140002


I need to get the average hour value in which the level operates, and then add the average hourly value of the level, and get the aumulado. The expected result is as follows:

Fecha_Hora Prom_Nivel_1
17/03/2022 11:00 1139988
17/03/2022 12:00 1139988
17/03/2022 13:00 883487
17/03/2022 14:00 1139999
17/03/2022 15:00 883496


I thought a measurement of AVEREANGE('sample'[Nivel_1]), but I should enter a filter so that I take only the four values I have per hour and average.

Ajunto the link of the files

https://drive.google.com/drive/folders/1KC5jCHSkqYPCifytcHjuIoZ7eH253Bps?usp=sharing

I look forward to commenting.

Best regards!

1 Reply