Forum Discussion
Solved
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 Table...
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!