Forum Discussion
Solved
How can I determine whether an order is placed by VIP with VIP history table
Hello, I have done my research but couldn't find any similar cases. My problem is I have two tables, one is the sales table Order id Customer ID Order Date Sales Region 1 12345...
TerenceM , You can get that value in first table and then check for it
a new column in the first table =
maxx(filter(VIP, VIP{Customer ID] = Sales[Customer ID] && Sales[Order Date] >= VIP[Start Date] && Sales[Order Date]<= VIP[End Date]) , VIP[TYPE of VIP] )
Thank you very much for your prompt reply! It works!