Looking for correlation between data in two seperate tables

Ken_Powerless — Thu, 26 Jan 2017 02:04:25 GMT

Setup:

I'm working with two tables. Both Tables have the fields User, Notes and Dates.

Both Tables can have multiple instances of the same user.

Problem:

A user can be in [table one], [table two], or both [table one] and [table two].

If a user is in table one and table two, and the date in table two is on or after the date of table one by seven days or less, then there is a correlation between the user being in table one and table two and I wish to pull that data and model it in Power BI.

Tried:

I tried creating a [new table] with unique values I pulled from [table one], then create a one to many relationship from that [new table] to [table one] and then also from the [new table] to [table two] between both the tables. To no avail

I have not been able to get this to work even for that without even worrying about the date parameters.

Any advice would be appreciated.

Also, I'm still very new to Power BI so feel free to talk down to me a bit.

Ken_Powerless Tracker

Looking for correlation between data in two seperate tables