Forum Discussion
Conditional Dynamic Dax Segregation on customer
Hi All , I am expecting Help on this to achive this logic I need to segregate user into three categories Active Customer, Super Active Customer,Hyper Active Customer
Based on the year and mon...
Hi,
Why has UserID 300004579 been classified as "Super Active Customer"? The minimum login value of this customer is 1,2. Share raw data in a format that can be pasted in an MS Excel file.
Hi Ashish_Mathur
,yes as u said the customer 300004579 should be active customer only, i mistakenly mapped to super active customer,
i am attaching segregation conditon, kindly have a look and let me know if you have any queries , and please provide solution
1 . Active Customer = if the Count of Login time is greater than equal to 1 for the entire selected 6 months and if minimum value is (1 ,2)then that user is active customer2. Super Active Customer = if the Count of Login time is greater than equal to 3 for the entire selected 6 months and if minimum value is 3 or 4 then that user is Super active Customer3.Hyper Active Customer = if the Count of Login time is greater than equal to 5 for the entire selected 6 months and if minimum value is 5 then that user is Hyper active CustomerRegards,
Alan P James
https://www.linkedin.com/in/alan-p-james-76b6aa16a/