Forum Discussion
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!
Hi, Syndicate_Admin
You can add a new calculated column as below to get the start of hour:
New Fecha_Hora = FORMAT(muestra[Fecha_Hora],"dd-mmm-yy hh:00:00")Then use this new measure to replace your original field 'Fecga_Hours' in table visual.
Please check my sample file for more details.
Best Regards,
Community Support Team _ Eason
1 Reply
- v-easonf-msft
Community Support
Hi, Syndicate_Admin
You can add a new calculated column as below to get the start of hour:
New Fecha_Hora = FORMAT(muestra[Fecha_Hora],"dd-mmm-yy hh:00:00")Then use this new measure to replace your original field 'Fecga_Hours' in table visual.
Please check my sample file for more details.
Best Regards,
Community Support Team _ Eason