Forum Discussion

crod21's avatar
crod21
New Member
4 years ago
Solved

New customer and returning customer Question

Hi All,

I am a new user powerBI user and trying out different things on the Desktop version.

The companies which have Deal Stage as Closed Won more than once in the table (refer Company 1, Company 4 and Company 6 in the image) neeto be labled as "Returning Customers" else It should be labeled as new customer.

Any suggestions so as to how do I go about with this?

Interesting Links
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    crod21 

    pls try this

    Column = if( countx(FILTER('Table','Table'[Company Name]=EARLIER('Table'[Company Name])&&'Table'[Deal Stage]="Closed Won"),'Table'[Company ID])>1,"Returning Customers","new customer")

3 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    4 years ago

    crod21 

    pls try this

    Column = if( countx(FILTER('Table','Table'[Company Name]=EARLIER('Table'[Company Name])&&'Table'[Deal Stage]="Closed Won"),'Table'[Company ID])>1,"Returning Customers","new customer")

  • crod21's avatar
    crod21
    New Member
    4 years ago

    ryan_mayu Thank you soo much for the solution. This works perfectly fine 🙂 
    Cheers mate 🙂