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.

AlanP514's avatar
AlanP514
Post Patron
2 years ago

Hai Ashish_Mathur 
As you said i am pasting mock data
Please find attached excel sheet , and please let me know the solution for achiving this customer segmentation based on the selection

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Since you have still not clarifies my previous doubt (asked yesterday), even if i download the file, i will not be able to help you.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Ashish_Mathur 

      Yes, As you mentioned the user 300004579

      Is should be in active customer not in super active because the minimum value is 1 

       

      Kindly have a look on the Excel sheet which I attached as mock data aswell as the logic 

      It would be great if you could provide solution on this

       

       

      Regards

      Alan p