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