Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Merging Queries based on time between two times

Hi there,   I need your thankful assistant for the below issue   I have calls data and duration as below   Caller ID    Call Start                          Call End 2030          9/1/2020 12:0...
  • HotChilli's avatar
    5 years ago

    In Power Query, add a column to the first table similar to this

    Table.SelectRows(TableY,
                    (r) =>
                        r[Ticket Created] > [Call Start]
                        and
                        r[Ticket Created] < [Call End]
                        and
                        r[Caller ID] = [Caller ID]
                )[Ticket Created]

    Swap in the name of the second table for TableY and the correct field names