Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Find status for a customer

Hi guys,   I am trying to build a report that can tell me whether a customer is new / current / lost. This depends on the when they last ordered something at the company. I thought I had it figur...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try based on date like

Summarize(Customer,Customer[Csutomer],"Status",
				Switch( True(),
					datediff(max(Reservations[Reservations Date]),today(),Year) >= 3 ,"Lost",
					datediff(max(Reservations[Reservations Date]),today(),Year) >= 0 ,"Current",
					"New"))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi amitchandak  thanks for the quick reply,

 

sadly this still gives all three results for most customers.