Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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.
User | Count |
---|---|
17 | |
14 | |
14 | |
13 | |
12 |
User | Count |
---|---|
19 | |
15 | |
15 | |
11 | |
10 |