Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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       ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    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

Jihwan_Kim's avatar
Jihwan_Kim
Super User
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