Is tableau has a opportunity to create calculated column for table? For example here are 2 column with some number and I want to make third column with formula like this
If(column1>column2;column1;column2
. I see there is option to create calculated field with summarize columns but I just want to compare them.
CodePudding user response:
If you only want to create a new column storing the max between 2 original column, you just need to create a calcultaed field like the following:
if column1 > column2
then column1
else column2
end