Calculation based on time condition

[kadapavel]

Hello 

I have a table with time stamps and values of load. Target is calculate load RMS values with some formula. for

Difficulty is..

I need to apply the calculation for every 10 minutes, 1hour of 24 hours to the time selected by slicer. for example

time stamp     Value

10:00:00           100%

10:01:00            120%

10:02:00             80%

10:04:00            110%

10:05:00             70%

10:08:00              20%

10:10:00              100%   >>  Time from 10:00:00 to 10:10:00 is >= 10 min, then apply caclulation for the time, then next..

I would appreciate for any ideas, currently I may do that(partly) only in excel using new columns with various conditions, but the imput data is so big that exel is not able to handle complete data.

[v-sihou-msft · Accepted solution]

@kadapavel

In this scenario, I suggest you add a column to group minute part of the time into 6 "buckets" in each hour. 

Minute Group = ROUNDDOWN(MINUTE('Table'[Time])/10,0)

Then you can use ALLEXCEPT() function to have your calculation group on each "bucket".

Regards,