Forum Discussion
Anonymous
5 years agoNot applicable
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...
- 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
HotChilli
5 years agoCommunity Champion
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