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 have an existing table that I want to add a new column to, using specifically matched data from another table.
The table I want to add to is named 'Case'. The table I want to pull from is called 'User'.
I have an established relationship between 'User'[ID] and 'Case'[OwnerID] - visualizations work perfectly to resolve Case number to Case owner name for instance.
What I'd like to do is populate a new column in the 'Case' table that displays the 'User'[Name] field for each line (case number). I know I could build a conditional colum, but was hoping there was a better way to look up the value and populate
"Case" | |
Case_Number | OwnerID |
22234 | QRF24B34OP |
22235 | QRF24B956T |
22236 | QRF24BBF21 |
22237 | QRF24BP09J |
"User" | |
ID | Name |
QRF24B34OP | Eric |
QRF24B956T | Mary |
QRF24BBF21 | Nassif |
QRF24BP09J | Vu |
Solved! Go to Solution.
Doh! I realized my mistake. Forgot the ' around the table name.
The better way for this is lookup function.
Doh! I realized my mistake. Forgot the ' around the table name.
Sorry, I should have mentioned that I did try the Lookupvalue function - this was the error "The syntax for 'Case' is incorrect. (DAX(LOOKUPVALUE(User[Name],User[ID],Case[OwnerID]))). "
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |