Forum Discussion

Babakhsn's avatar
Babakhsn
Icon for Helper I rankHelper 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.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
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.