Date comparison in set analysis

[Anonymous]

Hi!

I have 2 tables, one with customers who have used a discount code, and another that has all purchases for all customers.

I wan't to calculate all the purchases a customer has made after the customer has used a discount code. So if a customers uses 2 discount codes, one sale could end up in two columns, one for each discount code, if the sale date is after both discount code dates.

Attached is a simple Excel with how my data looks like.

[MK_QSL]

Can you also provide the result you are looking for in excel file?

[Anonymous]

I've added a third tab called "Result".

[MK_QSL · Accepted solution]

Create a Straight Table

Dimension

UserID

Expression

SUM(IF(OrderDate > DateUsedCode, Amount))