Forum Discussion
Anonymous
5 years agoNot applicable
undefined
Hi All, I have two tables, Project table and User table. I have to fetch the name of the project manager using DAX exp. Below is the table structure: Project table Project_ID Name ...
- 5 years ago
Hi, Anonymous
Please check the below. It is for creating a new column.
Project_Manager CC =LOOKUPVALUE(User[Name], User[User_ID],Project[Manager_ID])Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
amitchandak
5 years agoSuper User
Anonymous , You can join manager id with user id of use table and get the name
if already joined on another column, create one more inactive join and use userelationship to create a measure