Sum Data after every 30mins

[Anonymous]

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
01/09/2017 00:01	0.2
01/09/2017 00:05	0
01/09/2017 00:05	0.2
01/09/2017 00:10	0
01/09/2017 00:10	0.3
01/09/2017 00:15	0
01/09/2017 00:16	0.2
01/09/2017 00:20	0
01/09/2017 00:21	0.2
01/09/2017 00:25	0
01/09/2017 00:25	0.3
01/09/2017 00:30	0
01/09/2017 00:31	0.2
01/09/2017 00:35	0
01/09/2017 00:35	0.3
01/09/2017 00:41	0
01/09/2017 00:41	0.2
01/09/2017 00:45	0
01/09/2017 00:45	0.2
01/09/2017 00:50	0
01/09/2017 00:51	0.3
01/09/2017 00:55	0
01/09/2017 00:56	0.2
01/09/2017 01:00	0
01/09/2017 01:01	0.2
01/09/2017 01:05	0
01/09/2017 01:06	0.3
01/09/2017 01:10	0
01/09/2017 01:11	0.2
01/09/2017 01:15	0
01/09/2017 01:15	0.3
01/09/2017 01:20	0
01/09/2017 01:21	0.2
01/09/2017 01:25	0.2
01/09/2017 01:30	0

[v-sihou-msft]

@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,

[Anonymous]

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.

[Anonymous]

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,

[Anonymous]

Hi,

As mentioned,  I want my resulting data/chart to respond when i click a  slicer in my visual.

I want to be able to click a slicer, select a day in my first graph(stacked column) and the second graph (Line Graph) with the 'Sum Data after every 30mins' responds appropriately to the particlar day selected.

The 'Half Hourly Total' is not reponding when a particular slicer is selected.

Please where can i send you the PBIX file??

See how I want my graph to display

[Anonymous]

Hi,

 I have been looking around and still cant find any solution to 'Sum Data after every 30mins' and for it to respond to selected day