Forum Discussion
Circular Dependency?
Hello, I have a Customers table that’s linked to a Transactions Table and am using Direct Query mode. I’ve created a calculated column on the customers table that finds the date of the customer’s e...
Hi Beefheart
Please try
FirstSalesOrderDate =
MINX (
FILTER (
'Transaction',
'Transaction'[Type] = "Sales Order"
&& 'Transaction'[State] <> "Closed"
&& 'Transaction'[State] <> "Cancelled"
&& 'Transaction'[Customer Key] = 'Customers'[Customer Key]
),
'Transactions'[Date]
)
Hello taberj1,
Thank you for taking the time to consider my problem and reply. But I wasn't after a working dax query, sorry if I implied that.
What I want to know is why it's happening, what's causing this behaviour? And why does it happen when the two columns are in no way referencing each other? I want to learn what the issue is 🙂
Thanks again for your time!
Beefheart