FILTER( ALL(...and filtering with other columns

DAX DAX Calculations
1

Hi there,
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”?

Thanks!

2

Hi Brandon, give this a go:

Second Purchase Date =
CALCULATE( MIN( INVs[Date] ),
    FILTER( ALL( INVs ), 
        NOT INVs[Transaction Type] IN { "Credit Memo", "Return Authorization"} &&
        INVs[Date] > [First Purchase],
        VALUES( Customers[Customer ID] )
    )
)
3

Thanks, Melissa! My hero.