The product and customer dimension views retrieve both the surrogate key column used for relationships in the dataset as well as the business key that uniquely identifies the given product or customer, respectively. For example, the same product (FR-M94B-38) is represented by three product dimension rows (304, 305, 306) due to changes in its list price over time:
Slowly-changing dimension processing applied to Product Dimension
As discussed in Chapter 1, Planning Power BI Projects, the historical tracking of core business entities, such as customers and products, via slowly-changing dimension ETL processes is an ...
