Forum Discussion
Sum based on hours
Hi,
I have a requirement to find the sum of values in the forcasted next 4 hours. Here's how the sample data looks like
| Date | Hour | Values |
| 26/4/2022 | 22:00 | 20 |
| 27/4/2022 | 0:00 | 30 |
| 26/4/2022 | 23:00 | 10 |
| 26/4/2022 | 21:00 | 2 |
| 27/4/2022 | 1:00 | 50 |
| 27/4/2022 | 2:00 | 70 |
I need to sum the values from 21:00 of 26th april to 00:00 of 27th april. Can someone help me with the measure?
Thank you,
AV
AV_04 , if hour is in time format , create a date time field
Dateime = [Date] +[time]
A new measure =
calculate(sum(Table[Value]), filter(Table, Table[DateTime] >= now() && Table[DateTime] <= now() +time(4,0,0) ) )
In place of now, you can also use selected date and time too
2 Replies
AV_04 , if hour is in time format , create a date time field
Dateime = [Date] +[time]
A new measure =
calculate(sum(Table[Value]), filter(Table, Table[DateTime] >= now() && Table[DateTime] <= now() +time(4,0,0) ) )
In place of now, you can also use selected date and time too
Thank you, I made some twerks to the above measure and was able to get my requirement. Thank you 🙂
