If you've ever tried to join two tables in your Excel Power Pivot Data Model (or your Power BI Data Model), and been blocked by or warned about duplicate values, a Bridge Table may be just what you need. In this video Ken shows his preferred recipe for creating bridge tables, ensuring that you'll never have an orphaned record in your end results.
