Lookup for multiple values within 2 table

[NikkiSavage]

I have two separate tables. One has a list of customers with related incidents and the date (some listed multiple times for multiple incidents). 

I then have another table which states the movements of a customer on set dates including if they went to hospital. I need to do a look up in table 1 to say if a customer has had a fall and been to hospital within 2 days of that fall (looking up from table 2) to then return a positive value or "yes".

[Nathaniel_C · Accepted solution]

Hi @NikkiSavage , your easiest solution would to merge these two tables in power query.  If you would copy and paste your data into the message, rather than a picture, we could show you how to do that. 
If you would share your pbix, or dummy up some values in Excel both for current and expected data. Please copy and paste them into your post, rather than doing a picture, we may be able to help you, or provide a pbix. 

Please read this post to get your question answered more quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[NikkiSavage]

Hi

I can't seem to copy and paste pictures - it's saying I'm not allowed and then saying there is errors as my data contains html issues.

[NikkiSavage]

@Nathaniel_C  this is the error I get...Your post has been changed because invalid HTML was found in the message body. The invalid HTML has been removed. Please review the message and submit the message when you are satisfied. Will try and start a new query with the tables

[Nathaniel_C]

Hi @NikkiSavage , below you will find the steps to creating this solution and the pictures detailing those steps.  I didn't know your level of using Power Query so this may be overly detailed.  If you would prefer a third table, so that you kept your two in their original form, in the merge step, choose to save as a new table. The way the pics loaded, start from the bottom.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

10. Final product

9. Filter

8. Added conditional column

7.Added date col

6.Filtered Rows

5. Expanded columns

 4. Merged

3.Filtered rows for Hosp

2.Second table

 1. First table