Hi Community -
I am using the pattern below from the great SQLBI team. However, I think their pattern assumes a date table with direct relationship to Order Date on the sales table. I have a date table, but the primary relationship is to a different date (Due Date).
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. I've tried placing that function in several places, and nothing seems to work.
Any guidance is appreciated.
New and returning customers – DAX Patterns
Date New Customer =
MIN (SalesOrdersALL[Order Date]),