Create a New Column based on three new columns in the same table

[Anonymous]

Hello Friends, 

Need your advise, kindly help with the following table what is the better way to achieve results. 

Following the sample data set given to me. 

Self completed	Manager completed	Final completed
TRUE	TRUE	FALSE
TRUE	TRUE	TRUE
TRUE	FALSE	FALSE
TRUE	TRUE	TRUE
TRUE	TRUE	FALSE
TRUE	TRUE	FALSE
TRUE	TRUE	TRUE
TRUE	TRUE	FALSE
TRUE	TRUE	TRUE
TRUE	TRUE	TRUE
FALSE	FALSE	FALSE

 Based on the above data set need to create the following out put in new column of the same table. 

- Self Rating only
- Self and Manager Rating
- Complete

[Syndicate_Admin]

Thank you for your prompt response, this helps. Also, if self completed has false then it should consider as self completed.

[Watsky · Accepted solution]

Hi @Anonymous ,

Not sure if you're looking to add the column using a calculated column or through Power Query so here's both ways:

Power Query

1. Inside Power Query click on Add Column

2. Write out your new column like this:

if [Manager completed] = false then "Self Rating only" else if [Final completed] = false then "Self and Manager Rating" else "Complete"

Calculated Column

New Column = IF('Table'[Manager completed] = FALSE, "Self Completed",
IF('Table'[Final completed]=TRUE, "Completed","Self and Manager Rating"))