Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 | |
user 2 | |
user 3 | |
user 4 |
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 | Yes | |
user 2 | Yes | |
user 3 | Yes | |
user 4 | No |
Thanks
Solved! Go to Solution.
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" )
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" )
Please see the attached file
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |