How to grab a value from one column row based on a condition of another column row

[faronicus]

Hello,

Relatively new to Power BI. I am just using one table here. I just want to retrieve the value (simply get the value, no calculation) of one column, based on a condition of another column, and place that value into a new, third column.

So for example:

Animal             Type                New Column

Beaver              Mammal         

Lizard               Reptile

Monkey            Mammal

Snake                Reptile

If the Type = Mammal then I'd like the Animal value placed in New Column. How is this done??

Result should be this:

Animal              Type                New Column

Beaver               Mammal         Beaver

Lizard                 Reptile

Monkey             Mammal          Monkey

Snake                 Reptile

Bonus points for putting a value in the blanks, like "null" or "NA". Thanks.

[faronicus]

Thank you, that's what I wanted!

[Anonymous · Accepted solution]

Hi,@faronicus 
I am glad to help you.
You could try this:

New Column = IF('Table'[Type] = "Mammal", 'Table'[Animal], BLANK())

New Column2 = IF('Table'[Type] = "Mammal", 'Table'[Animal], "NA")

 the test result :

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.