Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
Solved! Go to 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.
Thank you, that's what I wanted!
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
8 | |
8 | |
8 | |
6 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
8 |