Forum Discussion

r_user's avatar
r_user
New Member
3 years ago

Power BI - Get value from a different table

Hi Community,   I was wondering if it is possible to do the following: I have two tables in PowerBI, one called "Project Overview" and another called "Project X". In the "Project Overview" table ...
General Comment
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

r_user , with the description, seems like you can have 1 to Many join between project X and Project overview

 

If you can have one to many join

 

then you can have a new column in DAX in project overview

 

related('Project X'[Start Date])

 

For any type of join

 

maxX(filter('Project X', 'project Overview'[project name]= 'Project X'[project name] ), 'Project X'[Start Date])