What formula to use for the new column

[Anonymous]

Hello,

What I want is to make a column where it checks data from the description and then gives the short assigned if the value matches else takes the value of that from Short form column and leave everything else as blank.

For example here in this picture, what formula should I apply in power bi so that I can get this column wanted. 

I have applied If formula - CL =  If(Description = "Casual Leave", "CL" , Short Form of description) 

but it is giving data like corrected columns I want and I dont want that. ( basically doesnt want result of other rows then rows searched.)

I will concatenate all the columns if I get Column wanted for every Description. 

thanks 

[amitchandak · Accepted solution]

@Anonymous, This should give you ?

CL = If(Description = "Casual Leave", "CL" , blank())