Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
The_Clam
Helper I
Helper I

Populate a column when datetime from one table is within 15 minutes of datetime on another table.

Hello All!

Please help!

I need to populate an ID1 column in Table1 from ID2 in Table2 WHEN Name1 from Table1 = Name2 from Table2 AND DateTime1 from Table1 is within 15 minutes of DateTime2 in Table2. Link of Power BI file below with datasets and what the result should look like. Thanks!

https://drive.google.com/file/d/107aN9Ogppupe68uSmgXSBcHR1P6AMz9C/view?usp=sharing

 

 

 

 

1 ACCEPTED SOLUTION

4 REPLIES 4
The_Clam
Helper I
Helper I

Community, nobody has answered my request yet. Please help! @Ritaf1983@amitchandak@lbendlin

lbendlin_0-1717425378544.png

 

The_Clam
Helper I
Helper I

@TomMartens , yes +/- 15 for the 2nd condition. Also, if there is more than one ID2 within +/- 15, then no problem, as long as it populates at least one. The data is provided in the Power BI link. Please help! Thanks!

TomMartens
Super User
Super User

Hey @The_Clam ,

 

I'm wondering if the 2nd condition "within 15 minutes" means, that the timerange of T2/N2 can span 
T1/N1/D1 -15min and T1/N1/D1 +15min
What happens if there are more than one ID2 l, e.g. when there is T2/ID2/D2-10 and T2/ID2/D2+11 ?

 

Next, please share the xlsx files as well, this is required to solve your requirement using Power Query.


Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.