Forum Discussion
Sum Data after every 30mins
Microsoft EmployeeAnonymous
In this scenario, you need to add Hour, Minute, and Date column in your table. Then create a first/second half hour bucket column based on Minute column. Now you can create measure to sum the Flow total group on Date, Hour, and Half Hour.
Hour = HOUR(Table6[DataTime])
Date = Table6[DataTime].[Date]
Minute = MINUTE(Table6[DataTime])
Half Hour = IF(Table6[Minute]<=30,"First Half","Second Half")
Half Hourly Total =
CALCULATE (
SUM ( Table6[FLOW] ),
ALLEXCEPT ( Table6, Table6[Date], Table6[Hour], Table6[Half Hour] )
)
Regards,
Hi,
Please how do I create Hour, Minute, and Date column.
How do I create a first/second half hour bucket column based on Minute column. ?/
Many Thanks
- v-sihou-msft
Anonymous
See my updated reply.
Hi ,
I've created Hour, Minute, and Date column.
I've also created a first/second half hour bucket column based on Minute column.
But the resulting sum of the data is the same value in all the 30mins intervals.
DataTime FLOW 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 01/09/2017 00:00 2940761.6 I've sent the pbix file to your mail.
Many Thanks for your help
- v-sihou-msft
Anonymous
I don't find any issue in your .pbix, it shows same total under each "Half Hour" (Your Minute column is based on DateTimePrevious, not DateTime) which is correct.
Regards,