How to count based on last 5 date columns?

[Anonymous]

Hello,

I have 2 columns valid to and valid from, i want to have column that will count Number column where Forklit is between 5 and 10, but  at certain time, at 6, 12 and 14:35, so basically I need to group date columns for every 5 records in every 5 minutes 
Something like this but without fixed date:
where valid_from <= to_date('20220831060000', 'YYYYMMDDHH24MISS') and valid_to > to_date('20220831060000', 'YYYYMMDDHH24MISS')

I should be able to see at the end this table:

Count of number from 06:00-06:05, then from 12:00-12:05 and from 14:35-14:40 for the last 2 days

Can someone help me with this please? 🙂

[Anonymous · Accepted solution]

Hi @Anonymous,

I'd like to suggest you add a calculated column to check the time value part of two DateTime fields to setting groups. That you can simply use the group to summary records.

You can also take a look at the following blog about segmentation if helps:

Static segmentation – DAX Patterns

Regards,

Xiaoxin Sheng