userelationship question and dax patterns

Question

Hi Community&nbsp; -&nbsp;&nbsp;I am using the pattern below from the great SQLBI team.&nbsp; &nbsp;However, I think their pattern assumes a date table with direct relationship to Order Date on the sales table.&nbsp; &nbsp;I have a date table, but the primary relationship is to a different date (Due Date).&nbsp; &nbsp; &nbsp;&nbsp;I do have an indirect relationship established with the Order Date and I can't change my relationships so I need to invoke the USERELATIONSHIP function.&nbsp; &nbsp;I've tried placing that function in several places, and nothing seems to work.&nbsp;&nbsp;Any guidance is appreciated.&nbsp; &nbsp; &nbsp;&nbsp;New and returning customers – DAX Patterns&nbsp;Date New Customer = CALCULATE(CALCULATE ( &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; MIN (SalesOrdersALL[Order Date]), &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; ALLEXCEPT ( &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SalesOrdersALL, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SalesOrdersALL[CustNum], &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dim_Customers&nbsp; &nbsp; )))

v-yalanwu-msft · Accepted Answer

Hi,&nbsp;Anonymous&nbsp;;
Try it.
Date New Customer =
    CALCULATE (
        MIN ( SalesOrdersALL[Order Date] ),
        ALLEXCEPT ( SalesOrdersALL, SalesOrdersALL[CustNum] ),
        USERELATIONSHIP ( SalesOrdersALL[CustNum], Dim_Customers[CustNum] )
    )

Or&nbsp;
Date New Customer =
CALCULATE (
    MIN ( SalesOrdersALL[Order Date] ),
    FILTER (
        ALL ( SalesOrdersALL ),
        SalesOrdersALL[CustNum] = MAX ( Dim_Customers[CustNum] )
    )
)

Best Regards,Community Support Team _ Yalan WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

userelationship question and dax patterns

1 Reply

Related content

Bookmark questions

RLS and USERELATIONSHIP problem

USERELATIONSHIP problems with n:m-relationship

Architecture question and brainstorming

Unpivot Question