Solved: Time span

Sajeerahammed · ‎11-04-2023

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, 08:38:41 AM
Carrefour City Centre	04-11-2023, 08:38:41 AM	04-11-2023, 08:42:38 AM
Carrefour City Centre	04-11-2023, 08:42:38 AM	04-11-2023, 08:42:48 AM
Carrefour City Centre	04-11-2023, 08:42:48 AM	04-11-2023, 09:18:20 AM
MONOPRIX SHOP	04-11-2023, 09:18:20 AM	04-11-2023, 09:18:33 AM
MONOPRIX SHOP	04-11-2023, 09:18:33 AM	04-11-2023, 09:34:57 AM
carrefour,landmark	04-11-2023, 09:34:57 AM	04-11-2023, 10:43:29 AM
carrefour,landmark	04-11-2023, 10:43:29 AM	04-11-2023, 10:43:40 AM
carrefour,landmark	04-11-2023, 10:43:40 AM	04-11-2023, 10:44:21 AM

Time	Required DAta
04-11-2023, 08:50:07 AM	Carrefour City Centre
04-11-2023, 09:36:30 AM	carrefour,landmark

There are two Data table.I would like to pull the location from first table according to time in 2nd table.But the problem is that mentioned time in 2nd table is precise and it is in between start time and end time in first table..Please help..

danextian · ‎11-04-2023

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]
    )
)

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

Sajeerahammed · ‎11-04-2023

Thanks brother...Problem solved