Forum Discussion

Babakhsn's avatar
Babakhsn
Helper I
2 years ago
Solved

Joining Two Tables

Hello Everyone, I have the two following tables:   Task Table:   Project Table:   In the task table, I want to have the last column (Status). It is not originally there, it's part ...
"DAX help"
Hints & Tips
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, Babakhsn 

     

    You can try the following methods.

    Column = CALCULATE(MAX('Project Table'[Status]),FILTER('Project Table',[Projectid]=EARLIER('Task Table'[Related Project Id])))
    Column 2 = LOOKUPVALUE('Project Table'[Status],'Project Table'[Projectid],[Related Project Id])

    Is this the result you expect? Please see the attached document.

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

philouduv's avatar
philouduv
Resolver III
2 years ago

Hello Babakhsn ,
In the Table view go on the Task Table(select it on the right side panel), click on new column and write :

- If a relation exist between the two tables (one to many on the ProjectID ==> Related project ID):
Status = CALCULATE(SELECTEDVALUE(Project_table[Status]))
-else (Meaning we would need to introduce the relationship directly into the dax formula)
Status = CALCULATE(SELECTEDVALUE(Project_table[Status]),FILTER(Project_table, Project_table[ProjectID] = Task_Table[Related project ID]))

Best regards,