Forum Discussion
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 having indirect relationship between both the tables.
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.
2 Replies
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/
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.
