Forum Discussion

Martijn1204's avatar
Martijn1204
Frequent Visitor
3 years ago
Solved

Defining new customer

Hi all,   I am a bit stuck with a difficult DAX function and I just can't get my head around it so maybe you guys can help me.   I want to define new customers and old customers, starting from th...
daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
3 years ago

Yeah... I think I now do understand the logic. Thanks for clarification. By the way, is it possible for you to give us some kind of data representative of your problem to work with? If so, please place a link to the file here.

  • Martijn1204's avatar
    Martijn1204
    Frequent Visitor
    3 years ago

    Hi,

    Thankyou alot, this really helps.

    Apologies for the late reaction as I had to tackle some urgent projects.

    This is exactly what I needed but there is an exception. 

     

    If their first purchase was on 01/01/2000, they are a "new customer" until 01/01/2001 (period of 12 months). But if they haven't bought anything in the upcoming 12 months, so from 01/01/2001 till 01/01/2002. They switch from "new customer" to "support customer". Do you think this is also possible?