Forum Discussion
Joining 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
That 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 |
bgierwi2 , Now join is 1-2 and 1-3 . File attached after signature