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'm trying to do a match based on 2 criteria from within the same table.
e.g.
My table looks like:
ID | employeeID | Affilliation | AffilliationType | titleFor |
1 | 12 | Internal Services | Division | |
2 | 5 | Health Care Protection | Unit | |
3 | 22 | Chief | Title | Unit |
4 | 46 | Consumer Services | Division | |
5 | 22 | Education & Communications | Unit | |
6 | 19 | Human Resources | Division |
I want to add a column that looks for a match of the employeeID and AffilliationType based on employeeID and titleFor of the record. The result would be:
ID | employeeID | Affilliation | AffilliationType | titleFor | titleAffilliation |
1 | 12 | Internal Services | Division | ||
2 | 5 | Health Care Protection | Unit | ||
3 | 22 | Chief | Title | Unit | Education & Communications |
4 | 46 | Consumer Services | Division | ||
5 | 22 | Education & Communications | Unit | ||
6 | 19 | Human Resources | Division |
Thanks in advance for any help or general direction for this.
Solved! Go to Solution.
You could do this with the DAX LookupValue function
eg.
You could do this with the DAX LookupValue function
eg.
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 |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |