topic How to grab a value from one column row based on a condition of another column row in DAX Commands and Tips

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

faronicus — Tue, 25 Jun 2024 13:09:55 GMT

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.

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

Anonymous — Wed, 26 Jun 2024 01:14:38 GMT

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.

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

faronicus — Mon, 01 Jul 2024 12:43:21 GMT

Thank you, that's what I wanted!