Hi, What I am trying to do is demonstrated in the following tables. So if there are repeated values in the last column (estimate) per customer in the same year, I want to keep only one value and leave the other ones blank. These repeated values are from the data source, which I have no control on. I would expect there to be one-to-many relationships between these tables and the fact table PaymentsTrimmed. The common link seems to be that all three affected look-up tables are generated via Power Query from a fact table. It works like this: 1) I import data to the query AllPaymentsPlus, which is basically all transactions on the system. On-premises data gateway (personal mode): Allows one user to connect to data sources and can't be shared with others. An on-premises data gateway (personal mode) can be used only with Power BI. This gateway is well suited to scenarios where you're the only one who creates reports and you don't need to share any data sources with others. Table expansion from the “many” to the “one” sides of one-to-many relationships is accomplished using LEFT OUTER JOIN semantics. A blank virtual row is added to the “one” side table when a matching value from the “many” side does not exist. Only regular relationships, not limited relationships, are subject to this behavior. Bi-directional relationships play an important role when creating the following two special model relationship types: One-to-one: All one-to-one relationships must be bi-directional—it isn't possible to configure otherwise. Generally, we don't recommend creating these types of relationships. For a complete discussion and alternative designs LGx4f8N.

bi one and only