Forum Discussion
Sum Data after every 30mins
Hi, My data is in every 5 mins but I need to sum it after every 30 mins. Please any workaround or DAX to achieve this?? See Sample Data Below: DataTime FLOW 01/09/2017 00:00 0 ...
Anonymous
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
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