Grouping data each 15 minutes

[aBerg]

Hi !

I would like a help for an application that I have to develop. I have a table (fData) with granularity of minutes and I need to group by every 15 minutes, according to the image.

Also the .PBIX application.

Thanks if anyone can help me !

Greetings ! 

[v-shex-msft]

Hi  @aBerg ,

You can write a measure to check minute part of datetime values to return tag, then drag it to visual level filter to keep Y result records:

IsQuarer =
IF ( MOD ( MINUTE ( MAX ( fData[DateTime] ) ), 15 ) = 0, "Y", "N" )

Regards,

Xiaoxin Sheng

[aBerg]

Hi @v-shex-msft !

Thank you for your time spent and return for help. 
Actually that way it is not quite what I need, so it's filtering the values every 15 minutes and in fact I need an average of the values every 15 minutes.

Please see the following file formula in Excel: Data.XLSX

Greetings !

[v-shex-msft · Accepted solution]

Hi @aBerg ,

You can add a calculate column to extract whole quarter datetime from datetime field, then use it and flowgas(summary mode average) to create a table visual.

Formula:

Datetime Group =
DATEVALUE ( [DateTime] )
    + TIME ( HOUR ( [DateTime] ), MINUTE ( [DateTime] )
        - MOD (
            MINUTE ( [DateTime] ),
            15
        ), 0 )

Regards,

Xiaoxin Sheng

[aBerg]

Hi Everyone !

Could someone help me and give me an idea how to implement it ?

Sorry, I really need that ...  

Grettings !