Creating a new table using a conditional column from another table in Excel

In this video I'm showing how to create a new table using a conditional column from another table in Power BI (can be applied to Excel). I'm focusing on duplicate and reference method and explaining the differences.

[@CasperLind1]

you just talk and show zero