Forum Discussion
Advocate IJoining 3 Data Sources with a Time Condition - Followup
Hi bgierwi2 ,
Based on the latest requirements, I have tested it on my end. Could you please review the screenshots and the PBIX file below.If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Community Support Team
Super Userbgierwi2 , Please see if the attached file can help
bgierwi2That is very close to what I am what I am looking for.
It looks like it is going to match all 3 rows only if all 3 match.
Is it possible to have the rows B and C matchup with the first row independently?
Railcar 2 matches with Table B but not Table C
Railcar 3 matches with Table C but not Table B
Your example is close, but it looks like it only matches if all 3 match.
Is matching B and C independently with A possible?
Batch Number - Batch Railcar Number - Batch Date - Batch Railcar Number - Rail Date - Rail Railcar Number - Switch Date - Switch A 1 10/1/2025 1 10/2/2025 1 10/3/2025 B 2 10/2/2025 2 10/3/2025 2 10/4/2026 C 3 10/3/2025 3 10/5/2025 33 10/4/2025 D 4 10/4/2025 4 12/4/2026 44 10/6/2025 - amitchandak
bgierwi2 , Now join is 1-2 and 1-3 . File attached after signature