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 two tables with Cost Centers and UserID's. I want to move the details from table A over to table B.
Table 1 - Take the users form table 2 that match table 1 and pull their Cost Center over in a new column
User | Cost Center |
chad | 1111 |
jeff | 2222 |
mat | 3333 |
sam | 4444 |
Table 2
User | Cost Center |
Chad | 5555 |
jeff | 6666 |
frank | 9999 |
mat | 8888 |
Solved! Go to Solution.
Probably:
Column = LOOKUPVALUE('Table 2'[Cost Center ],'Table 2'[User],[User])
PBIX attached
Probably:
Column = LOOKUPVALUE('Table 2'[Cost Center ],'Table 2'[User],[User])
PBIX attached
Hey Greg,
This works perfect as a measure, but now that i see the measure in action i realize a measure won't work as i need to do additional transformations on these Cost Centers. So i really need it as a column, instead of a calcualted column. Thats why I was thinking something like a append or merge?
Any ideas? I checked append and thats out of the question, merge looks a bit to much as it looks to merge all the fields?
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 |
---|---|
40 | |
19 | |
18 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |