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...
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")

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")