Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
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

    Anonymous 

    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

Anonymous 

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