Row level Comparision

[AW_analyst]

Hi All,

From the below data I want to compare first 2 columns and build a new column to know new user or exsiting user. I'm able to achieve this under Excel but not in Incorta.

[JoeM · Accepted solution]

Using a formula, you could use a case statement like the following: 

case([Users]=[Last Month User],'Existing','New User')