conditional column

[dw700d]

I have two columns, A parent column which gives the name of each parent and a child column that represents the type of child each parent has. I would like to create a new column within the query editor that tells me if a parent has a toddler, an infant or both. For example the new column would  show that John has “both”, Tom has “Toddler”, Mike has “infant” and Bob has “Both”

Parent	Child
John	Toddler
John	infant
John	infant
Tom	Toddler
Tom	Toddler
Tom	Toddler
Mike	infant
Mike	infant
Mike	infant
Bob	Toddler
Bob	infant
Bob	infant

[VijayP · Accepted solution]

@dw700d  This solution may help you! Please share your Kudos
Find attached pbix File