Forum Discussion

srl01's avatar
srl01
Helper II
8 years ago

Flagging a customer's second visit

Hello -    I have a table of raw sales transaction data (one line per item, multiple lines for a transaction, with a unique transaction code for each transaction).   Date Transaction code Cu...
Need Help
srl01's avatar
srl01
Helper II
8 years ago

Update - this is what I have so far but it isn't working...

 

Is2ndVisit = if(calculate (distinctcount([TransactionCode]),
filter(all(CustomerMaster), CustomerMaster[CustomerCode]=min(CustomerMaster[CustomerCode])), 
FILTER (ALL ( 'Calendar' ), 'Calendar'[Date] < MIN ( 'Calendar'[Date])))=1, 1, 0)

Anyone able to assist?