Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Custom Column

If Table 1 has a common feild as table two then bring third column from Table two in Table 1. IF Table1(ID) = Table2(ID) Than Return Table2(Name) Not able to create direct relationship due to havi...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    According to your statement, I know there is no relationship between two tables. I suggest you to try code as below to achieve your goal.

    Name from Table 2 =
/*Workaround 1: If you have one name for one ID*/
CALCULATE (
    MAX ( Table2[Name] ),
    FILTER (
        Table2,
        Table2[ID] = EARLIER ( Table1[ID] )
    ) /*Workaround 2: If you have multiple names for one ID
CONCATENATEX(FILTER(Table2,Table2[ID] = EARLIER(Table1[ID])),Table2[Name],",")*/
)

    Result is as below.

     

    Best Regards,

    Rico Zhou

     

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

     

SamInogic's avatar
SamInogic
Icon for Super User rankSuper User
3 years ago

Hi Anonymous 

You can use Lookup function in DAX expression as below,

column1 = Lookup(table2, Table2(ID), Table(1)ID, Table2(Name)

Thanks!

 

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at [email protected]

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/