Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dynamic Month Based Calculated Column for Customer Classification

Hello all,   I have stuck at some Customer needs. My app needs to find the Customer type based on date. I have a little table that shows the Customer's need. For example,  we have 3 types o...
General Comment
Need Help
Show and Tell
Tips and Tricks
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi,  Anonymous 

The screenshot you provided has confused me even more. Can you explain this in more detail?
Why is the record (a 1.05.2021 100) classified as  new customer rather than  existing  customer?

Why is the record (b 1.04.2021 10) classified as  existing  customer rather than  new  customer?

Best Regards,
Community Support Team _ Eason

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi , 

     

    we have customer field at Fact Table. So we need to identify the customer types.

    The record (a 1.05.2021 100)  is classified as a new customer beacuse when we look at last 3 months the customer sold items at latest month.

    The record (b 1.04.2021 10)  is not classified as a new customer because in 3 months customer sold items at for 3 months.

     

    Table is a bit confusing sorry. If you want we can discuss with screensharing. This problem is very urgent upgrade for customer to patch.

     

    Thanks.