Conditional Comparing tables

[Anonymous]

Hi guys!

I need to compare two diffent tables (more than 6mi rows each one) with conditionals. like a VLOOKUP + IF function or more specifically, index + match in excel.

In table 1, i need to figure out if exists in table 2 and if so, how many days are between each one (there's a date column) - I need only the diference <= 30 days. But i can have the same ID more than once with differents dates. 

Thanks!!!

[Anonymous]

Hi @Anonymous ,

Sounds like Merge Queries.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data#combine-queries

Better to share some sample data and expected result to us.

Best Regards,

Jay

[parry2k]

@Anonymous please provide sample data. Read this post to get your answer quickly.

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

[Anonymous]

Hi,

sorry, my bad!

here's a sample data. The situation is like:

1) Step1 - Everyday, I send an e-mail to customers about outstading payments.

2) Step2 - Everyday, i check all the payments we've received and compare to our list in step 1 (ID_CLIENT in  step 2might be in step1 or not)

Table C = Notifications E-mail

Table R = Payments

Trying to solve it, in table R i've checked if CLIENT_ID in table R exists in table C:

now, I'm trying to have something like:

if column vlookup = X, go to table C and get the latest date considering the column DATE in table R (in table C, i can have the same ID_CLIENT more than once -- with differents dates)

Thanks!!