Filter minutes in one table by start/stop times in another table

[bookhouseboy]

So this is probably very easy but I can't get it right. I have

• one table with
  • one column of date/time by the minute,
  • and another column with number of transactions conducted in that minute
• and another table with
  • one column with the names of certain events,
  • one column of date/time by the minute for the start of each event and
  • one column of date/time for the end of each event.

I just want to slice by event name and show the number of transactions only for minutes during the event selected.

I know this can't be hard but it just won't work. Can someone just point me in the right direction?

[bookhouseboy]

This looks very promising. I'll have to make a few adjustments, but I can see a path to success now. Thank you!

Edit: It works! Thank you so much!

[Anonymous · Accepted solution]

Hi @bookhouseboy 

You can refetr to the following sample

Table1

Table 2

Create a measure

Measure =
IF (
    ISFILTERED ( 'Table (2)'[Events] ),
    CALCULATE (
        SUM ( 'Table'[Number] ),
        FILTER (
            'Table',
            [Date] >= MAX ( 'Table (2)'[StartDate] )
                && 'Table'[Date] < MAX ( 'Table (2)'[End Date] )
        )
    ),
    CALCULATE ( SUM ( 'Table'[Number] ) )
)

 Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.