Data blending
Data blending is a way of using different fields from different data sources in one Worksheet. There is always a primary data source (the tick icon in blue) and one or more secondary data sources (the tick mark in orange). As for joins, one or multiple common fields are needed to create the relationships between the data sources.
Unlike joins, data blending is often used to add new Measures. Fields coming from the secondary data sources are always aggregated. However, they are only aggregated using the common fields between the two data sources, so there is no data duplication. However, data blending can rapidly have a negative impact on performance.
Fields with the same name can automatically be used to create a relationship. In the secondary data sources, you can recognize the fields that can be used for the relationship with the small link icon next to their name. You can click on the link icon to enable or disable them. For example, in the following screenshot, both Order...
