Role Playing dimensions with duplicated queries

For modeling overview, it is either you have a single date dimension and 3 reltionships with your fact table, linked to it one active and 2 inactive : (from Dim Date to your Fact table ) :

• Due Date to Date SK : 1 to many relationship
• Order Date to Date SK : 1 to many relationship
• Delivery Date to Date SK : 1 to many relationship

You need to make sure that the Dim Date contains unique values and in this case you call it a conformed/shared dimension.

Or you can have 3 role playing dimensions for dates that you call Dim Due Date, Dim Order Date and Dim Delivery date, you eliminate the dupliactes from the Due date and reference the 2 other queries.

So to achieve that the answer A is correct but as a best practice I would go for No.

When you reference a query, it's as though the steps in the referenced query are combined with, and run before, the steps in the referencing query3. You can duplicate a query to get an exact copy of the query with all steps, or reference a query to create a reference to the original query instead as a new query. The formula bar contains the syntax for referencing a specific row and column within Power Query.