Forum Discussion

Frequent Visitor

4 years ago

Solved

Combine 2 tables based on datetime in one table falling between start/end datetime columns in other

Hi, The following Table A has a start and end DateTime column (Event Frame Start Time & Event Frame End Time): I then have the following Table B: Is it possible to create a new tab...

Need Help

wdx223_Daniel
4 years ago
New DAX Query=GENERATE(TableA,FILTER(SUMMARISE(TableB,TableB[Date_Time],TableB[Category]),TableB[Date_Time]>=TableA[Event Frame Start Time]&&TableB[Date_Time]<=TableA[Event Frame End Time]))

wdx223_Daniel

Community Champion

4 years ago

New DAX Query=GENERATE(TableA,FILTER(SUMMARISE(TableB,TableB[Date_Time],TableB[Category]),TableB[Date_Time]>=TableA[Event Frame Start Time]&&TableB[Date_Time]<=TableA[Event Frame End Time]))

Forum Discussion

Combine 2 tables based on datetime in one table falling between start/end datetime columns in other

Related content

Error in Power Query combining overlapping start end datetime fields

Converting Epoch Datetime into regular datetime format

Create DateTime List between start datetime & end DateTime

Convert DateTime to Date

MAX datetime truncates to date???