Forum Discussion
Solved
Time span
Dear All, I have particular issue. Location Start Time End Time Start 04-11-2023, 08:01:23 AM 04-11-2023, 08:38:25 AM Carrefour City Centre 04-11-2023, 08:38:25 AM 04-11-2023, 0...
Hi Sajeerahammed ,
Try this calc column in Table02:
Location = CALCULATE ( MAX ( Table01[Location] ), FILTER ( Table01, EARLIER ( Table02[Time] ) <= Table01[End Time] && EARLIER ( Table02[Time] ) >= Table01[Start Time] ) )Thanks brother...Problem solved
Hi Sajeerahammed ,
Try this calc column in Table02:
Location =
CALCULATE (
MAX ( Table01[Location] ),
FILTER (
Table01,
EARLIER ( Table02[Time] ) <= Table01[End Time]
&& EARLIER ( Table02[Time] ) >= Table01[Start Time]
)
)
Brother...
Can we add salesman criteria also on desired output??thanks in advance for your support
| Start | Salesman Name | Start Time | End Time |
| Start | 04-11-2023, 08:01:23 AM | 04-11-2023, 08:38:25 AM | |
| Carrefour City Centre | Suraj | 04-11-2023, 08:38:25 AM | 04-11-2023, 08:38:41 AM |
| Carrefour City Centre | Suraj | 04-11-2023, 08:38:41 AM | 04-11-2023, 08:42:38 AM |
| Carrefour City Centre | Suraj | 04-11-2023, 08:42:38 AM | 04-11-2023, 08:42:48 AM |
| Carrefour City Centre | Suraj | 04-11-2023, 08:42:48 AM | 04-11-2023, 09:18:20 AM |
| MONOPRIX SHOP | Suraj | 04-11-2023, 09:18:20 AM | 04-11-2023, 09:18:33 AM |
| MONOPRIX SHOP | Suraj | 04-11-2023, 09:18:33 AM | 04-11-2023, 09:34:57 AM |
| carrefour,landmark | Raja | 04-11-2023, 09:34:57 AM | 04-11-2023, 10:43:29 AM |
| carrefour,landmark | Raja | 04-11-2023, 10:43:29 AM | 04-11-2023, 10:43:40 AM |
| carrefour,landmark | Raja | 04-11-2023, 10:43:40 AM | 04-11-2023, 10:44:21 AM |
| Time | Salesman | Desired output |
| 04-11-2023, 08:50:07 AM | Suraj | Carrefour City Centre |
| 04-11-2023, 09:36:30 AM | Raja | carrefour,landmark |