Creating a column based to value of 2 others

[Anonymous]

Hi 

I need to add a coumn to my report, based on the value of 2 other columns but only have a value where the specific values are met, anything else should be null or blank. 

Status	Owner	New Column
Open	John Smith	If Status = Open & Owner = John Smith then value = "In Remediation" else blank
Closed	John Smith	if status = Closed & Owner = John Smith then value = "Remediaiton Closed" else blank

What I'm trying to acheive i've added to the "New Column" above, is there an easy way to acheive this?

[Data-estDog]

Click on transform. Select table: 

Click add column tab. Click Custom column

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

[Uzi2019 · Accepted solution]

Hi @Anonymous 
Please create calculated column as below:
New column= IF('Table'[status]="Open" && 'Table'[Owner]="John Smith","In Remediation", IF(Table'[status]="Close" && 'Table'[Owner]="John Smith","Remediaiton Closed",Blank()))

Let me know your answer!

[Anonymous]

Thank you! this worked perfectly