I have this DAX for Second Purchase Date but what it actually returns is Second Transaction Date. I’m having trouble figuring out how to include a filter that suppresses Credits and Returns.
Second Purchase Date =
CALCULATE( MIN( INVs[Date] ),
FILTER( ALL( INVs ), INVs[Date] > [First Purchase],
VALUES( Customers[Customer ID] )
Is there a way for me to add INVs[Transaction Type] to filter out if Transaction Type = “Credit Memo” or “Return Authorization”?