Multiples JOINS same table

tex628 Thanks for your reply. It's working but it quickly becomes slow in power query and for tables with 1k to 5k rows. Maybe I'm doing it wrong or to much in power query

v-yanjiang-msftThanks for your reply too. I understand why there is an ambiguity and the concept of different paths. The problematic is to tell to bowerbi "in that vizualization use that path, in this other vizualization use the other path, ..."

Let's say that we have the tables "order" and "invoice" that are related. Each one can be related to a "customer" table. In some case, we need to list the orders with theirs customers, in other case list the invoices with the customers. There are two paths, both could be used in different contexts.

I did in power query but it begins to be very slow.