If a row out of many contains a value return value in another table

[powerbinoob457]

I've got a a bunch of users who are assigned corporate phones.

Some users ony have 1 phone while others have multiples.

The date is organized in two tables one containing the asset information and one containing user information as below

User	Phone Type	serial
user 1	Iphone	0
user 1	Android	1
user 2	Iphone	2
user 2	Iphone	3
user 3	Iphone	4
User 4	Android	5

and

User	email address
user 1	email
user 2	email
user 3	email
user 4	email

User is unique in this table.

I need to create a calculated column in the second that that will identify all IOS users as such

User	Phone Type	Uses IOS
user 1	email	Yes
user 2	email	Yes
user 3	email	Yes
user 4	email	No

Thanks

[Zubair_Muhammad · Accepted solution]

HI @powerbinoob457

You can use this Column in Table 2 assuming Tables are linked via User Column

Column =
IF (
    CONTAINS ( RELATEDTABLE ( Table1 ), Table1[Phone Type], "IPhone" ),
    "Yes",
    "No"
)

[Zubair_Muhammad]

@powerbinoob457

Please see the attached file