Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Using the "IF" function to create a new column

Hello,   I need to create a new column and it must use the condition "IF", for example: = If (Provider = '05521463000112 - CAMARA MUNICIPAL TERESINA', 'Transfer to Camara'  if (Provider = '4125...
Need Help
Sean's avatar
Sean
Community Champion
10 years ago

Anonymous

 

Column = IF ( TableName[Provider Column]="'05521463000112 - CAMARA MUNICIPAL TERESINA", "Transfer to Camara",

                  IF ( TableName[Provider Column]="41256744000159 -. IPMT- INST.PREV.DOS SERV MUN" , "Transfer to IPMT ) )

 

Why do you need SUM?

 

Do need to CONCATENATE something?