Does Customer have same value in multiple columns

[wmeyer]

I have a table called Customer Base, that contains all customer transactions, with columns for Customer ID, Transaction Month, and Lost Month (meaning if they havent purchased before that date they are considered lost).  I'm trying to calculate, if the lost month for that customer transaction = the start month for any of that customer's orders, then not blank, otherwise 1. In other words, if the customer purchases in the "lost month" then we don't want to consider them lost, we want to consider them reacquired.  

I have tried to use the lookup function, but i can't figure out how to look up by Customer.

[v-piga-msft · Accepted solution]

Hi @wmeyer，

I'm not very clear about your expected output. I have create  a calculated column and get the result like below.

If you want to get the output above, you could have a reference of the formula below.

Column = LOOKUPVALUE('Table'[Lost Month],'Table'[Lost Month],'Table'[Start of Month of Transaction Date])

Column 2 = LOOKUPVALUE('Table'[Start of Month of Transaction Date],'Table'[Start of Month of Transaction Date],'Table'[Lost Month])

If you still need help, please show your desired output, so that we can help further investigate on it?

Best regards,

Cherry