Forum Discussion

AlanP514's avatar
AlanP514
Post Patron
2 years ago

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...
Need Help
Show and Tell
Tips and Tricks
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hai Ashish_Mathur 

Customer 300004579 login count is greater than 3 and if the minimum value is 3 or 4 for selected 6 months

Then that customer should be super active customer

So based on this condition I can say mentioned customer is super active , we can categorise while seeing login count of this user's data

 

I will provide you the sample data of this

But big thanks Ashish_Mathur  your response

I will provide you the data

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    You are welcome.  I am confused.  For that customer, the minimum count is 1 and therefore he should be Active not Super Active.