NEW COLUMN

[paris]

Hi All,

I have Sales table and would like to add Category colulmn by using New Column in modeling function. 

If Products are Apple or Orange or Banana, I would like to add Fruits in category. 

Can you help to write fomular?

All the best,

Paris

[Anonymous · Accepted solution]

Try this calculated Column

Category = IF(([Products]="Apple" || [Products]="Orange" || [Products]="Banana"),"Fruits","")

Let me know if it helps!

[paris]

Thank you very much for your help!